private bool SaveDetail()
{
bool blnResult = false;
cDeduct oDeduct = new cDeduct();
try
{
string strUserName = Session["username"].ToString();
StoreDetail();
foreach (DataRow dr in this.dtDeductDetail.Rows)
{
if (Helper.CStr(dr["recv_item_code"]).Trim().Length > 0)
{
var detail = new Deduct_detail
{
deduct_doc_no = txtdeduct_doc.Text,
deduct_detail_id = Helper.CLong(dr["deduct_detail_id"]),
recv_item_code = Helper.CStr(dr["recv_item_code"]),
recv_item_rate = Helper.CDec(dr["recv_item_rate"]),
deduct_item_amount = Helper.CDec(dr["deduct_item_amount"]),
deduct_item_is_director = Helper.CBool(dr["deduct_item_is_director"]),
deduct_item_remark = Helper.CStr(dr["deduct_item_remark"]),
c_created_by = strUserName,
c_updated_by = strUserName
};
if (Helper.CStr(dr["row_status"]) == "N")
{
oDeduct.SP_DEDUCT_DETAIL_INS(detail);
}
else if (Helper.CStr(dr["row_status"]) == "O")
{
oDeduct.SP_DEDUCT_DETAIL_UPD(detail);
}
else if (Helper.CStr(dr["row_status"]) == "D")
{
oDeduct.SP_DEDUCT_DETAIL_DEL(detail.deduct_detail_id);
}
}
}
this.dtDeductDetail = null;
blnResult = true;
}
catch (Exception ex)
{
throw ex;
}
finally
{
oDeduct.Dispose();
}
return(blnResult);
}
private bool saveData()
{
bool blnResult = false;
string strUpdatedBy = string.Empty;
strUpdatedBy = Session["username"].ToString();
CheckBox chkSelect;
Label lblrecv_item_code = null;
Label lblrecv_item_name = null;
AwNumeric txtrecv_item_rate = null;
CheckBox chkRecv_item_is_director = null;
var oDeduct = new cDeduct();
Deduct_detail deduct_detail = null;
try
{
foreach (GridViewRow gvRow in GridView1.Rows)
{
chkSelect = (CheckBox)gvRow.FindControl("chkSelect");
var select = Request.Form[chkSelect.UniqueID];
if (select != null && select == "on")
{
lblrecv_item_code = (Label)gvRow.FindControl("lblrecv_item_code");
lblrecv_item_name = (Label)gvRow.FindControl("lblrecv_item_name");
txtrecv_item_rate = (AwNumeric)gvRow.FindControl("txtrecv_item_rate");
chkRecv_item_is_director = (CheckBox)gvRow.FindControl("chkRecv_item_is_director");
var recv_item_rate = decimal.Parse(txtrecv_item_rate.Value.ToString());
deduct_detail = new Deduct_detail
{
deduct_doc_no = ViewState["deduct_doc"].ToString(),
recv_item_code = lblrecv_item_code.Text,
recv_item_rate = recv_item_rate,
deduct_item_amount = decimal.Parse(ViewState["recv_total_amount"].ToString()) * recv_item_rate / 100,
deduct_item_is_director = chkRecv_item_is_director.Checked,
c_created_by = strUpdatedBy
};
oDeduct.SP_DEDUCT_DETAIL_INS(deduct_detail);
}
blnResult = true;
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
finally
{
oDeduct.Dispose();
}
return(blnResult);
}
public bool SP_DEDUCT_DETAIL_INS(Deduct_detail deduct_detail)
{
bool blnResult = false;
SqlConnection oConn = new SqlConnection();
SqlCommand oCommand = new SqlCommand();
SqlDataAdapter oAdapter = new SqlDataAdapter();
try
{
oConn.ConnectionString = _strConn;
oConn.Open();
oCommand.Connection = oConn;
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.CommandText = "sp_DEDUCT_DETAIL_INS";
SqlParameter oParamdeduct_detail_id = new SqlParameter("deduct_detail_id", SqlDbType.BigInt);
oParamdeduct_detail_id.Direction = ParameterDirection.Output;
oParamdeduct_detail_id.Value = deduct_detail.deduct_detail_id;
oCommand.Parameters.Add(oParamdeduct_detail_id);
oCommand.Parameters.Add("deduct_doc_no", SqlDbType.VarChar).Value = deduct_detail.deduct_doc_no;
oCommand.Parameters.Add("recv_item_code", SqlDbType.VarChar).Value = deduct_detail.recv_item_code;
oCommand.Parameters.Add("recv_item_rate", SqlDbType.Money).Value = deduct_detail.recv_item_rate;
oCommand.Parameters.Add("deduct_item_amount", SqlDbType.Money).Value = deduct_detail.deduct_item_amount;
oCommand.Parameters.Add("deduct_item_is_director", SqlDbType.Bit).Value = deduct_detail.deduct_item_is_director;
oCommand.Parameters.Add("deduct_item_remark", SqlDbType.VarChar).Value = deduct_detail.deduct_item_remark;
oCommand.Parameters.Add("c_created_by", SqlDbType.VarChar).Value = deduct_detail.c_created_by;
oCommand.ExecuteNonQuery();
deduct_detail.deduct_detail_id = long.Parse(oParamdeduct_detail_id.Value.ToString());
blnResult = true;
}
catch (Exception ex)
{
throw ex;
}
finally
{
oConn.Close();
oCommand.Dispose();
oConn.Dispose();
}
return(blnResult);
}
