protected void btnSave_Click(object sender, EventArgs e)
{
Int64 Result = 0;
invoicetransport objinvoicetransport = new invoicetransport();
objinvoicetransport.transporterid = Convert.ToInt64(hftransporter.Value);
objinvoicetransport.customerid = Convert.ToInt64(hfcustomer.Value);
objinvoicetransport.lrno = txtlrno.Text.Trim();
objinvoicetransport.lrdate = Convert.ToDateTime(txt_Date.Text.Trim());
objinvoicetransport.invoiceno = hfinvoiceno.Value;
objinvoicetransport.freightamount = Convert.ToDecimal(txtfreightamount.Text.Trim());
objinvoicetransport.total = Convert.ToDecimal(txttotal.Text.Trim());
Result = (new Cls_invoicetransport_b().Insert(objinvoicetransport));
if (Result > 0)
{
Clear();
spnMessgae.InnerText = "Invoice Transport Saved Successfully !!!";
//Response.Redirect(Page.ResolveUrl("~/manageEmployee.aspx?mode=i"));
}
else
{
Clear();
spnMessgae.Style.Add("color", "red");
spnMessgae.InnerText = "Invoice Transport Not Saved...";
}
}
/*
*
* public DataTable SelectAll(invoicetransport objinvoicetransport)
* {
* DataSet ds = new DataSet();
* SqlDataAdapter da;
* try
* {
* SqlCommand cmd = new SqlCommand
* {
* CommandText = "invoicetransport_SelectAll",
* CommandType = CommandType.StoredProcedure,
* Connection = ConnectionString
* };
*
* ConnectionString.Open();
* da = new SqlDataAdapter(cmd);
* da.Fill(ds);
* }
* catch (Exception ex)
* {
* ////ErrHandler.writeError(ex.Message, ex.StackTrace);
* return null;
* }
* finally
* {
* ConnectionString.Close();
* }
* return ds.Tables[0];
* }
* public invoicetransport SelectById(Int64 id)
* {
* SqlDataAdapter da;
* DataSet ds = new DataSet();
* invoicetransport objinvoicetransport = new invoicetransport();
* try
* {
* SqlCommand cmd = new SqlCommand
* {
* CommandText = "invoicetransport_SelectById",
* CommandType = CommandType.StoredProcedure,
* Connection = ConnectionString
* };
* cmd.Parameters.AddWithValue("@id", id);
* 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)
* {
* //[id],[productid],[sizeid],[colorid],[createdby],[createddate],[isdeleted]
*
* objinvoicetransport.Id = Convert.ToInt64(ds.Tables[0].Rows[0]["id"]);
* objinvoicetransport.Productid = Convert.ToInt64(ds.Tables[0].Rows[0]["productid"]);
* //objinvoicetransport.Sizeid = Convert.ToInt64(ds.Tables[0].Rows[0]["sizeid"]);
* objinvoicetransport.Sizeid = ds.Tables[0].Rows[0]["sizeid"].ToString();
* objinvoicetransport.Colorid = ds.Tables[0].Rows[0]["colorid"].ToString();
* objinvoicetransport.Createdby = Convert.ToInt64(ds.Tables[0].Rows[0]["createdby"]);
* //objinvoicetransport.isdeleted = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["isdeleted"].ToString()) ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["isdeleted"]);
* objinvoicetransport.Createddate = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["createddate"].ToString()) ? DateTime.MinValue : Convert.ToDateTime(ds.Tables[0].Rows[0]["createddate"]);
* //objinvoicetransport.orderstatus = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["orderstatus"].ToString()) ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["orderstatus"]);
*
*
*
*
*
* }
* }
* }
* }
* }
* catch (Exception ex)
* {
* ////ErrHandler.writeError(ex.Message, ex.StackTrace);
* return null;
* }
* finally
* {
* ConnectionString.Close();
* }
* return objinvoicetransport;
* }
*
*
*
*/
public Int64 Insert(invoicetransport objinvoicetransport)
{
Int64 result = 0;
try
{
// id, transporterid, customerid, lrno, lrdate, invoiceno, freightamount, total, createddate, isdeleted
SqlCommand cmd = new SqlCommand
{
CommandText = "invoicetransport_Insert",
CommandType = CommandType.StoredProcedure,
Connection = ConnectionString
};
SqlParameter param = new SqlParameter
{
ParameterName = "@id",
Value = 0,
SqlDbType = SqlDbType.BigInt,
Direction = ParameterDirection.InputOutput
};
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@transporterid", objinvoicetransport.transporterid);
cmd.Parameters.AddWithValue("@customerid", objinvoicetransport.customerid);
cmd.Parameters.AddWithValue("@lrno", objinvoicetransport.lrno);
cmd.Parameters.AddWithValue("@lrdate", objinvoicetransport.lrdate);
cmd.Parameters.AddWithValue("@invoiceno", objinvoicetransport.invoiceno);
cmd.Parameters.AddWithValue("@freightamount", objinvoicetransport.freightamount);
cmd.Parameters.AddWithValue("@total", objinvoicetransport.total);
//cmd.Parameters.AddWithValue("@createddate", DateTime.Now);
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);
}
