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)); }