public Customer_orders SelectById(Int64 oid)
{
SqlDataAdapter da;
DataSet ds = new DataSet();
Customer_orders objorders = new Customer_orders();
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Customer_orders_SelectById";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
cmd.Parameters.AddWithValue("@oid", oid);
ConnectionString.Open();
da = new SqlDataAdapter(cmd);
da.Fill(ds);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
{
objorders.oid = Convert.ToInt64(ds.Tables[0].Rows[0]["oid"]);
objorders.uid = Convert.ToInt64(ds.Tables[0].Rows[0]["uid"]);
objorders.productquantites = Convert.ToInt32(ds.Tables[0].Rows[0]["productquantites"]);
objorders.billpaidornot = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["billpaidornot"].ToString()) ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["billpaidornot"]);
objorders.amount = Convert.ToDecimal(ds.Tables[0].Rows[0]["amount"]);
objorders.discount = Convert.ToDecimal(ds.Tables[0].Rows[0]["discount"]);
objorders.tax = Convert.ToDecimal(ds.Tables[0].Rows[0]["tax"]);
objorders.totalamount = Convert.ToDecimal(ds.Tables[0].Rows[0]["totalamount"]);
objorders.orderdate = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["orderdate"].ToString()) ? DateTime.MinValue : Convert.ToDateTime(ds.Tables[0].Rows[0]["orderdate"]);
objorders.isdelete = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["isdelete"].ToString()) ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["isdelete"]);
objorders.isCreateInvoice = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["isCreateInvoice"].ToString()) ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["isCreateInvoice"]);
objorders.orderno = Convert.ToString(ds.Tables[0].Rows[0]["orderno"]);
objorders.ordertype = Convert.ToString(ds.Tables[0].Rows[0]["ordertype"]);
}
}
}
}
}
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(null);
}
finally
{
ConnectionString.Close();
}
return(objorders);
}
public Int64 Insert(Customer_orders objorders)
{
Int64 result = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Customer_orders_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = ConnectionString;
SqlParameter param = new SqlParameter();
param.ParameterName = "@oid";
param.Value = objorders.oid;
param.SqlDbType = SqlDbType.BigInt;
param.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@uid", objorders.uid);
cmd.Parameters.AddWithValue("@productquantites", objorders.productquantites);
cmd.Parameters.AddWithValue("@billpaidornot", objorders.billpaidornot);
cmd.Parameters.AddWithValue("@amount", objorders.amount);
cmd.Parameters.AddWithValue("@discount", objorders.discount);
cmd.Parameters.AddWithValue("@tax", objorders.tax);
cmd.Parameters.AddWithValue("@totalamount", objorders.totalamount);
cmd.Parameters.AddWithValue("@orderdate", objorders.orderdate);
cmd.Parameters.AddWithValue("@isdelete", objorders.isdelete);
cmd.Parameters.AddWithValue("@usertype", objorders.usertype);
cmd.Parameters.AddWithValue("@orderno", objorders.orderno);
cmd.Parameters.AddWithValue("@ordertype", objorders.ordertype);
ConnectionString.Open();
cmd.ExecuteNonQuery();
result = Convert.ToInt64(param.Value);
}
catch (Exception ex)
{
ErrHandler.writeError(ex.Message, ex.StackTrace);
return(result);
}
finally
{
ConnectionString.Close();
}
return(result);
}
