public FrameWork.ReceiveOrders[] allPO()
{
string query = "SELECT a.[ID] ,b.[Company],b.[Address],[CreationDate],SupplierID, [ExpectedDate],[PaymentAmount],b.[TIN],b.[EmailAddress],a.[CreatedById],a.[ClosedById],b.[BusinessPhone] FROM [dbo].ReceiveOrders a inner join [dbo].[Suppliers] b on a.SupplierID = b.ID order by a.id asc";
DataTable table = new DataTable();
table = DataAccess.DBAdapter.GetRecordSet(query);
FrameWork.ReceiveOrders[] dec = new FrameWork.ReceiveOrders[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
dec[i] = new FrameWork.ReceiveOrders(table.Rows[i]);
}
return dec;
}
protected void btnSave_Click(object sender, EventArgs e)
{
dtgridList = (DataTable)ViewState["dtgridList"];
string users = Session["id"].ToString();
decimal totalamt = 0;
try
{
FrameWork.ReceiveOrders RRO = new FrameWork.ReceiveOrders();
FrameWork.ReceiveOrderDetails PROsub = new ReceiveOrderDetails();
busReceiveOrders busPRO = new busReceiveOrders();
RRO.SupplierID = int.Parse(this.drpSupplier.SelectedValue);
RRO.CreatedById = int.Parse(users);
string x = busPRO.insertRR(RRO);
foreach (DataRow dr in dtgridList.Rows)
{
PROsub.ReceiveOrderID = int.Parse(x);
PROsub.Quantity = Single.Parse(dr["Quantity"].ToString());
PROsub.ProductID = int.Parse(dr["ProductID"].ToString());
busPRO.insertReceiveOrderDetails(PROsub);
}
}
catch (Exception ex)
{
}
finally
{
this.txtQuantity.Text = string.Empty;
this.txtUOM.Text = string.Empty;
this.drpProduct.SelectedValue = "0";
this.lblDescription.Text = string.Empty;
//this.txtUnitPrice.Text = string.Empty;
this.drpSupplier.SelectedValue = "0";
// this.txtTerms.Text = string.Empty;
DataTable ds = new DataTable();
ds = null;
this.grdList.DataSource = ds;
grdList.DataBind();
}
}
public string insertRR(ReceiveOrders drsi)
{
string Message = string.Empty;
int result = 0;
SqlTransaction transaction;
con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO [dbo].ReceiveOrders ([SupplierID],[CreatedById],[CreationDate],[IsCompleted],[IsSubmitted],[IsNew]) VALUES (@SupplierID,@CreatedById,getdate(),@IsCompleted,@IsSubmitted,@IsNew)", con);
cmd.CommandText = "InsertRR";
cmd.Parameters.AddWithValue("@SupplierID", drsi.SupplierID);
cmd.Parameters.AddWithValue("@CreatedById", drsi.CreatedById);
//cmd.Parameters.AddWithValue("@ExpectedDate", drsi.ExpectedDate);
//cmd.Parameters.AddWithValue("@PaymentAmount", drsi.PaymentAmount);
cmd.Parameters.AddWithValue("@IsCompleted", 1);
cmd.Parameters.AddWithValue("@IsSubmitted", 1);
cmd.Parameters.AddWithValue("@IsNew", 1);
transaction = con.BeginTransaction();
cmd.Transaction = transaction;
//cmd.Parameters.AddWithValue("@OrderBy", drsi.OrderBy);
//cmd.Parameters.AddWithValue("@CheckBy", drsi.CheckBy != null ? drsi.CheckBy : string.Empty);
try
{
result = cmd.ExecuteNonQuery();
transaction.Commit();
}
catch (Exception ex)
{
try
{
transaction.Rollback();
}
catch (Exception ex2)
{
// This catch block will handle any errors that may have occurred
// on the server that would cause the rollback to fail, such as
// a closed connection.
Console.WriteLine("Rollback Exception Type: {0}", ex2.GetType());
Console.WriteLine(" Message: {0}", ex2.Message);
}
}
con.Close();
string query = "select top 1 ID from [ReceiveOrders] order by id desc";
DataTable dt = new DataTable("Customer");
dt.Clear();
dt = DataAccess.DBAdapter.GetRecordSet(query);
if (dt.Rows.Count > 0)
{
Message = dt.Rows[0]["ID"].ToString();
}
return Message;
}