public static int ClaimDisbursement_Save(Entity.ClaimManagement.ClaimDisbursement claimDisbursement)
{
int rowsAffacted = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_HR_ClaimDisbursement_Save";
cmd.Parameters.AddWithValue("@ClaimDisburseId", claimDisbursement.ClaimDisbursementId).Direction = ParameterDirection.InputOutput;
cmd.Parameters.AddWithValue("@VoucherId", claimDisbursement.VoucherId);
cmd.Parameters.AddWithValue("@CreatedBy", claimDisbursement.CreatedBy);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.ExecuteNonQuery();
rowsAffacted = Convert.ToInt32(cmd.Parameters["@ClaimDisburseId"].Value);
con.Close();
}
}
return(rowsAffacted);
}
public static DataTable ClaimDisbursement_GetAll(Entity.ClaimManagement.ClaimDisbursement claimDisbursement)
{
using (DataTable dt = new DataTable())
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_HR_ClaimDisbursement_GetAll";
if (string.IsNullOrEmpty(claimDisbursement.VoucherNo))
{
cmd.Parameters.AddWithValue("@VoucherNo", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@VoucherNo", claimDisbursement.VoucherNo);
}
if (claimDisbursement.FromDate == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@FromDate", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@FromDate", claimDisbursement.FromDate);
}
if (claimDisbursement.ToDate == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@ToDate", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@ToDate", claimDisbursement.ToDate);
}
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
}
}
return(dt);
}
}
public DataTable ClaimDisbursement_GetAll(Entity.ClaimManagement.ClaimDisbursement claimDisbursement)
{
return(DataAccess.ClaimManagement.ClaimDisbursement.ClaimDisbursement_GetAll(claimDisbursement));
}
public int ClaimDisbursement_Save(Entity.ClaimManagement.ClaimDisbursement claimDisbursement)
{
return(DataAccess.ClaimManagement.ClaimDisbursement.ClaimDisbursement_Save(claimDisbursement));
}
