public static int Voucher_Save(Entity.ClaimManagement.Voucher voucher) { 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_Voucher_Save"; cmd.Parameters.AddWithValue("@VoucherId", voucher.VoucherId).Direction = ParameterDirection.InputOutput; cmd.Parameters.AddWithValue("@VoucherJson", voucher.VoucherJson); cmd.Parameters.AddWithValue("@CreatedBy", voucher.CreatedBy); if (con.State == ConnectionState.Closed) { con.Open(); } cmd.ExecuteNonQuery(); rowsAffacted = Convert.ToInt32(cmd.Parameters["@VoucherId"].Value); con.Close(); } } return(rowsAffacted); }
public static DataSet Voucher_GetAll(Entity.ClaimManagement.Voucher voucher) { using (DataSet ds = new DataSet()) { 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_Voucher_GetAll"; if (string.IsNullOrEmpty(voucher.VoucherNo)) { cmd.Parameters.AddWithValue("@VoucherNo", DBNull.Value); } else { cmd.Parameters.AddWithValue("@VoucherNo", voucher.VoucherNo); } if (voucher.FromDate == DateTime.MinValue) { cmd.Parameters.AddWithValue("@FromDate", DBNull.Value); } else { cmd.Parameters.AddWithValue("@FromDate", voucher.FromDate); } if (voucher.ToDate == DateTime.MinValue) { cmd.Parameters.AddWithValue("@ToDate", DBNull.Value); } else { cmd.Parameters.AddWithValue("@ToDate", voucher.ToDate); } if (string.IsNullOrEmpty(voucher.EmployeeName)) { cmd.Parameters.AddWithValue("@EmployeeName", DBNull.Value); } else { cmd.Parameters.AddWithValue("@EmployeeName", voucher.EmployeeName); } cmd.InsertPaging(voucher, voucher.VoucherId); if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(ds); } con.Close(); } } return(ds); } }
public DataSet Voucher_GetAll(Entity.ClaimManagement.Voucher voucher) { return(DataAccess.ClaimManagement.Voucher.Voucher_GetAll(voucher)); }
public int Voucher_Save(Entity.ClaimManagement.Voucher voucher) { return(DataAccess.ClaimManagement.Voucher.Voucher_Save(voucher)); }