C#

Mycroft Holmes wrote:

Here is one reason I ALWAYS use a stored proc, the delete procedure check the FK

Mycroft Holmes wrote:

and only deletes the record if there is no constraint.

public static bool DeletePayType(int PayTypeId)
{
    using (var dc = getDataContext())
    {

        bool inUse = isPayTypeInUse(PayTypeId);

        if (inUse)
        {
            return false;
        }
        else
        {
            var payType = (from ca in dc.PayTypes
                            where ca.PayTypeId == PayTypeId
                            select ca).FirstOrDefault();

            if (payType != null)
            {
                dc.PayTypes.DeleteOnSubmit(payType);

                try
                {
                    dc.SubmitChanges();
                    return true;
                }
                catch (Exception e)
                {
                    throw e;
                }
            }
        }
    }
}

Pete O'Hanlon wrote:

I'm not a big fan of exceptions to control business logic

class DeletePayTypeResult {
    public bool Deleted { get; set; }
    public string ReasonNotDeleted { get; set; }
}

public static DeletePayTypeResult DeletePayType(int PayTypeId)
{
}

Kevin Marois wrote:

What's the best way to notify the front end of a business rule or possible FK
violation?

Kevin Marois wrote:

Throwing an exception doesn't seem right

Shibbi wrote:

Please help me out

Dominik wrote:

if I have to explicity need to set the Transaction in the Command/Connection Object or if this is done implicity

Dominik wrote:

My second question would be, if it is not done explicity: I actually create an Instance of another class within the TransactionScope where I do all the database operations, is there a way to access the open Transaction without passing the scope variable as a method parameter?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

lordoftrades wrote:

Does anyone know how to do this?

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

public override void OnShutdown()
        {
       	string[] row = new string[7];
       	double Close;
       	string currentLine;
       	var dates_in_IQB = new List<DateTime>();
       	int i = 0;
       
       	DateTime endDate =new DateTime(DateTimeEnd());
    	DateTime startDate = new DateTime (DateTimeStart());
                                   
           for (var x = startDate; x <= endDate; x = x.AddDays(1)){
           //This loop to get a complete list of dates and values 
                       	i = i + 1;
                       	dates_in_IQB.Add(x);
                       	double equity = AccountHistoryEquity(0, i);
                                               
                                   
OutputWriteLine(String.Format("Date {0}, Equity {1}",x ,equity)); //Complete list of 365 days pr year
									   
if(Directory.Exists(_filePath)){  //Checking if the path exists...
string lines =  String.Format("{0}, {1}", x, equity); //Writing the daily equity changes for all accounts...
// Write the string to a file.                                                                                                 System.IO.StreamWriter file = new System.IO.StreamWriter(_filePath +"\\ref1.txt", true);{
file.WriteLine(lines, i);
file.Close();
}
}
   }
                                           
           DataTable dt = new DataTable();
           dt.Columns.Add(new DataColumn("date", typeof(DateTime)));
           dt.Columns.Add(new DataColumn("close", typeof(double)));
               
           string theURL = @"http://ichart.finance.yahoo.com/table.csv?s=msft" 
                + @"&a=" + (startDate.Month - 1).ToString() 
                + @"&b=" + startDate.Day.ToString() 
                + @"&c=" + startDate.Year.ToString() 
                + @"&d=" + (endDate.Month - 1).ToString() 
                + @"&e=" + endDate.Day.ToString() 
                + @"&f=" + endDate.Year.ToString() 
                + @"&g=d&ignore=.csv";

            HttpWebRequest request = (HttpWebRequest)WebRequest.Create(theURL);
            HttpWebResponse response = (HttpWebResponse)request.GetResponse();

            Stream resStream = response.GetResponseStream();
            StringBuilder sb = new StringBuilder();
            byte[] buf = new byte[8192];
            string tempString = null;
            int count = 0;

            do
            {
                count = resStream.Read(buf, 0, buf.Length);
                if (count != 0)
                {
                    tempString = Encoding.ASCII.GetString(buf, 0, count);
                    sb.Append(tempString);
                }
            }
            while (count > 0);

            string data = sb.ToString();
            String[] data2 = data.Split('\n');
            int iteration = 0;
            double[] open;
            double[] high;
            double[] low;
            double[] close;
            double[] volume;
            double[] adjClose;

            DateTime[] dates = new DateTime[data2.Length - 2];
            open = new double[data2.Length - 2];
            high = new double[data2.Length - 2];
            low = new double[data2.Length - 2];
            close = new double[data2.Length - 2];
            volume = new double[data2.Length - 2];
            adjClose = new double[data2.Length - 2];

            foreach (string strLine in data2)
            {
                String[] entries = strLine.Split(',');
                if ((iteration != 0) && (entries[0] != ""))
                {
                    dates[iteration - 1] = System.Convert.ToDateTime(entries[0]);
                    open[iteration - 1] = System.Convert.ToDouble(entries[1]);
                    high[iteration - 1] = System.Convert.ToDouble(entries[2]);
                    low[iteration - 1] = System.Convert.ToDouble(entries[3]);
                    close[iteration - 1] = System.Convert.ToDouble(entries[4]);
                    volume[iteration - 1] = System.Convert.ToDouble(entries[5]);
                    adjClose[iteration - 1] = System.Convert.ToDouble(entries[6]);
                                                           
    dt.Rows.Add(new object[] {dates[iteration - 1], close[iteration - 1]}); //Writing from yahoo to datatable
					

// OutputWriteLine(String.Format("Date {0}, Close {1}", dates[iteration - 1], close[iteration - 1]));
                }
  iteration = iteration + 1;
            }
                                   
        // Code to lookup missing dates in the datas from Yahoo, and make it ready for comparisement with IQB's data
        DateTime minDT = dt.Rows.Cast<DataRow>().Min(row1 => (DateTime)row1["date"]);
        DateTime maxDT = dt.Rows.Cast<DataRow>().Max(row1 => (DateTime)row1["date"]);
		

        // Create all the dates that should be in table
        List<DateTime> dts = new List<DateTime>();
        DateTime DT = minDT;
        while (DT <= maxDT)
        {
            dts.Add(DT);
            DT = DT.AddDays(1);
        }
            // Find the dates that should be in table but aren't
        var DTsNotInTable = dts.Except(dt.Rows.Cast<DataRow>().Select(row1 => (DateTime)row1["date"]));

	
        foreach (DateTime dateTime in DTsNotInTable)
		
        dt.Rows.Add(dateTime, 0); //ADDING A ZERO TO THE STOCK QUOTE WHEN A MISSING DAY IS ADDED
		
        // Order the results collection
        var ordered = dt.Rows.Cast<DataRow>().OrderBy(row1 => (DateTime)row1["date"]);

        // Create a DataTable object where missing dates are filled in together with close-values = 0
        DataTable dt2 = ordered.CopyToDataTable();
                        
                        
                                   foreach (DataRow row1 in dt2.Rows) // Loop over the rows.
                                   {
OutputWriteLine(String.Join(",", row1.ItemArray));
									   
string lines =  (String.Join(",", row1.ItemArray)); //Writing the daily equity changes for all accounts...
// Write the string to a file.                                                                                                   
System.IO.StreamWriter file = new System.IO.StreamWriter(_filePath +"\\ref1.txt", true);{
file.WriteLine(lines);
file.Close();
 }
					//***************************************************************************************
								   }
								   
        }