public static List <DCCollector> GetDuplicateDCCollectorList(string dccollectorName, string fatherName, string dateofBirth, bool allOffices = false, bool showDeleted = false) { List <DCCollector> TheDCCollectorList = GetDCCollectorList(allOffices, showDeleted); List <DCCollector> TheDuplicateDCCollectorList = new List <DCCollector>(); if (TheDCCollectorList.Count > 0) { var DuplicateDCCollectorList = (from DCCollectorList in TheDCCollectorList where DCCollectorList.DCCollectorName.ToUpper() == dccollectorName.ToUpper() && DCCollectorList.FatherName.ToUpper() == fatherName.ToUpper() && DCCollectorList.DateOfBirth.ToUpper() == dateofBirth.ToUpper() select DCCollectorList).ToList(); foreach (DCCollector EachDCCollector in DuplicateDCCollectorList) { DCCollector TheDCCollector = (DCCollector)EachDCCollector; TheDuplicateDCCollectorList.Add(TheDCCollector); } } return(TheDuplicateDCCollectorList); }
public static DCCollector GetDCCollectorsById(int DCCollectorID) { DataRow DCCollectorRow = DCCollectorDataAccess.GetInstance.GetDCCollectorsById(DCCollectorID); DCCollector TheDCCollectorRow = DataRowToObject(DCCollectorRow); return(TheDCCollectorRow); }
public int UpdateDCCollector(DCCollector theDCCollector) { int ReturnValue = 0; using (SqlCommand UpdateCommand = new SqlCommand()) { UpdateCommand.CommandType = CommandType.StoredProcedure; UpdateCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; UpdateCommand.Parameters.Add(GetParameter("@DCCollectorID", SqlDbType.Int, theDCCollector.DCCollectorID)); UpdateCommand.Parameters.Add(GetParameter("@Salutation", SqlDbType.VarChar, theDCCollector.Salutation)); UpdateCommand.Parameters.Add(GetParameter("@DCCollectorName", SqlDbType.VarChar, theDCCollector.DCCollectorName)); UpdateCommand.Parameters.Add(GetParameter("@FatherName", SqlDbType.VarChar, theDCCollector.FatherName)); UpdateCommand.Parameters.Add(GetParameter("@SpouseName", SqlDbType.VarChar, theDCCollector.SpouseName)); UpdateCommand.Parameters.Add(GetParameter("@Gender", SqlDbType.VarChar, theDCCollector.Gender)); UpdateCommand.Parameters.Add(GetParameter("@MaritalStatus", SqlDbType.VarChar, theDCCollector.MaritalStatus)); UpdateCommand.Parameters.Add(GetParameter("@DateOfBirth", SqlDbType.VarChar, theDCCollector.DateOfBirth)); UpdateCommand.Parameters.Add(GetParameter("@Age", SqlDbType.Int, theDCCollector.Age)); UpdateCommand.Parameters.Add(GetParameter("@Address_Present_TownOrCity", SqlDbType.VarChar, theDCCollector.Address_Present_TownOrCity)); UpdateCommand.Parameters.Add(GetParameter("@Address_Present_Landmark", SqlDbType.VarChar, theDCCollector.Address_Present_Landmark)); UpdateCommand.Parameters.Add(GetParameter("@Address_Present_PinCode", SqlDbType.VarChar, theDCCollector.Address_Present_PinCode)); UpdateCommand.Parameters.Add(GetParameter("@Address_Present_DistrictID", SqlDbType.Int, theDCCollector.Address_Present_DistrictID)); UpdateCommand.Parameters.Add(GetParameter("@Address_Permanent_TownOrCity", SqlDbType.VarChar, theDCCollector.Address_Permanent_TownOrCity)); UpdateCommand.Parameters.Add(GetParameter("@Address_Permanent_Landmark", SqlDbType.VarChar, theDCCollector.Address_Permanent_Landmark)); UpdateCommand.Parameters.Add(GetParameter("@Address_Permanent_PinCode", SqlDbType.VarChar, theDCCollector.Address_Permanent_PinCode)); UpdateCommand.Parameters.Add(GetParameter("@Address_Permanent_DistrictID", SqlDbType.Int, theDCCollector.Address_Permanent_DistrictID)); UpdateCommand.Parameters.Add(GetParameter("@Phone", SqlDbType.VarChar, theDCCollector.Phone)); UpdateCommand.Parameters.Add(GetParameter("@Mobile", SqlDbType.VarChar, theDCCollector.Mobile)); UpdateCommand.Parameters.Add(GetParameter("@Email", SqlDbType.VarChar, theDCCollector.Email)); UpdateCommand.Parameters.Add(GetParameter("@Qualification", SqlDbType.VarChar, theDCCollector.Qualification)); UpdateCommand.Parameters.Add(GetParameter("@Occupation", SqlDbType.VarChar, theDCCollector.Occupation)); UpdateCommand.Parameters.Add(GetParameter("@Nationality", SqlDbType.VarChar, theDCCollector.Nationality)); UpdateCommand.Parameters.Add(GetParameter("@Religion", SqlDbType.VarChar, theDCCollector.Religion)); UpdateCommand.Parameters.Add(GetParameter("@Caste", SqlDbType.VarChar, theDCCollector.Caste)); UpdateCommand.Parameters.Add(GetParameter("@Photo", SqlDbType.VarBinary, theDCCollector.Photo)); UpdateCommand.Parameters.Add(GetParameter("@Signature", SqlDbType.VarBinary, theDCCollector.Signature)); UpdateCommand.Parameters.Add(GetParameter("@DateOfJoining", SqlDbType.VarChar, theDCCollector.DateOfJoining)); UpdateCommand.Parameters.Add(GetParameter("@DCCollectorPassword", SqlDbType.VarChar, theDCCollector.DCCollectorPassword)); UpdateCommand.Parameters.Add(GetParameter("@MaximumCollectionAmountAllowed", SqlDbType.Decimal, theDCCollector.MaximumCollectionAmountAllowed)); UpdateCommand.Parameters.Add(GetParameter("@MaximumMinutesAllowed", SqlDbType.Int, theDCCollector.MaximumMinutesAllowed)); UpdateCommand.Parameters.Add(GetParameter("@MaximumTransactionsAllowed", SqlDbType.Int, theDCCollector.MaximumTransactionsAllowed)); UpdateCommand.Parameters.Add(GetParameter("@CanDownloadMaster", SqlDbType.Bit, theDCCollector.CanDownloadMaster)); UpdateCommand.Parameters.Add(GetParameter("@CanDoTransactions", SqlDbType.Bit, theDCCollector.CanDoTransactions)); UpdateCommand.Parameters.Add(GetParameter("@CanPrintDuplicateReceipts", SqlDbType.Bit, theDCCollector.CanPrintDuplicateReceipts)); UpdateCommand.Parameters.Add(GetParameter("@CanCancelTransaction", SqlDbType.Bit, theDCCollector.CanCancelTransaction)); UpdateCommand.Parameters.Add(GetParameter("@OfficeID", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.OfficeID)); UpdateCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); UpdateCommand.CommandText = "pCRM_DCCollectors_Update"; ExecuteStoredProcedure(UpdateCommand); ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString()); return(ReturnValue); } }
public int DeleteDCCollector(DCCollector theDCCollector) { int ReturnValue = 0; using (SqlCommand DeleteCommand = new SqlCommand()) { DeleteCommand.CommandType = CommandType.StoredProcedure; DeleteCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output; DeleteCommand.Parameters.Add(GetParameter("@DCCollectorID", SqlDbType.Int, theDCCollector.DCCollectorID)); DeleteCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID)); DeleteCommand.CommandText = "pCRM_DCCollectors_Delete"; ExecuteStoredProcedure(DeleteCommand); ReturnValue = int.Parse(DeleteCommand.Parameters[0].Value.ToString()); return(ReturnValue); } }
public static List <DCCollector> GetDCCollectorList(bool allOffices = false, bool showDeleted = false) { List <DCCollector> DCCollectorList = new List <DCCollector>(); DataTable DCCollectorTable = new DataTable(); DCCollectorTable = DCCollectorDataAccess.GetInstance.GetDCCollectorList(allOffices, showDeleted); foreach (DataRow dr in DCCollectorTable.Rows) { DCCollector TheDCCollector = DataRowToObject(dr); DCCollectorList.Add(TheDCCollector); } return(DCCollectorList); }
public int DeleteDCCollector(DCCollector theDCCollector) { return(DCCollectorIntegration.DeleteDCCollector(theDCCollector)); }
public int UpdateDCCollector(DCCollector theDCCollector) { return(DCCollectorIntegration.UpdateDCCollector(theDCCollector)); }
public int InsertDCCollector(DCCollector theDCCollector) { return(DCCollectorIntegration.InsertDCCollector(theDCCollector)); }
public static DCCollector DataRowToObject(DataRow dr) { DCCollector TheDCCollector = new DCCollector(); TheDCCollector.DCCollectorID = int.Parse(dr["DCCollectorID"].ToString()); TheDCCollector.Salutation = dr["Salutation"].ToString(); TheDCCollector.DCCollectorName = dr["DCCollectorName"].ToString(); TheDCCollector.DCCollectorCode = dr["DCCollectorCode"].ToString(); TheDCCollector.FatherName = dr["FatherName"].ToString(); TheDCCollector.SpouseName = dr["SpouseName"].ToString(); TheDCCollector.Gender = dr["Gender"].ToString(); TheDCCollector.MaritalStatus = dr["MaritalStatus"].ToString(); TheDCCollector.DateOfBirth = DateTime.Parse(dr["DateOfBirth"].ToString()).ToString(MicroConstants.DateFormat); TheDCCollector.Age = int.Parse(dr["Age"].ToString()); TheDCCollector.Address_Present_TownOrCity = dr["Address_Present_TownOrCity"].ToString(); TheDCCollector.Address_Present_Landmark = dr["Address_Present_Landmark"].ToString(); TheDCCollector.Address_Present_PinCode = dr["Address_Present_PinCode"].ToString(); TheDCCollector.Address_Present_DistrictID = int.Parse(dr["Address_Present_DistrictID"].ToString()); TheDCCollector.Address_Present_DistrictName = dr["Address_Present_DistrictName"].ToString(); TheDCCollector.Address_Present_CountryName = dr["Address_Present_CountryName"].ToString(); TheDCCollector.Address_Present_StateName = dr["Address_Present_StateName"].ToString(); TheDCCollector.Address_Permanent_TownOrCity = dr["Address_Permanent_TownOrCity"].ToString(); TheDCCollector.Address_Permanent_Landmark = dr["Address_Permanent_Landmark"].ToString(); TheDCCollector.Address_Permanent_PinCode = dr["Address_Permanent_PinCode"].ToString(); TheDCCollector.Address_Permanent_DistrictID = int.Parse(dr["Address_Permanent_DistrictID"].ToString()); TheDCCollector.Address_Permanent_DistrictName = dr["Address_Permanent_DistrictName"].ToString(); TheDCCollector.Address_Permanent_StateName = dr["Address_Permanent_StateName"].ToString(); TheDCCollector.Address_Permanent_CountryName = dr["Address_Permanent_CountryName"].ToString(); TheDCCollector.Phone = dr["Phone"].ToString(); TheDCCollector.Mobile = dr["Mobile"].ToString(); TheDCCollector.Email = dr["Email"].ToString(); TheDCCollector.Qualification = dr["Qualification"].ToString(); TheDCCollector.Occupation = dr["Occupation"].ToString(); TheDCCollector.Nationality = dr["Nationality"].ToString(); TheDCCollector.Religion = dr["Religion"].ToString(); TheDCCollector.Caste = dr["Caste"].ToString(); if (!string.IsNullOrEmpty(dr["Photo"].ToString())) { TheDCCollector.Photo = (byte[])dr["Photo"]; } if (!string.IsNullOrEmpty(dr["Signature"].ToString())) { TheDCCollector.Signature = (byte[])dr["Signature"]; } TheDCCollector.DateOfJoining = DateTime.Parse(dr["DateOfJoining"].ToString()).ToString(MicroConstants.DateFormat); TheDCCollector.DCCollectorPassword = dr["DCCollectorPassword"].ToString(); TheDCCollector.MaximumCollectionAmountAllowed = decimal.Parse(dr["MaximumCollectionAmountAllowed"].ToString()); TheDCCollector.MaximumMinutesAllowed = int.Parse(dr["MaximumMinutesAllowed"].ToString()); TheDCCollector.MaximumTransactionsAllowed = int.Parse(dr["MaximumTransactionsAllowed"].ToString()); TheDCCollector.CanDownloadMaster = bool.Parse(dr["CanDownloadMaster"].ToString()); TheDCCollector.CanDoTransactions = bool.Parse(dr["CanDoTransactions"].ToString()); TheDCCollector.CanCancelTransaction = bool.Parse(dr["CanCancelTransaction"].ToString()); TheDCCollector.CanPrintDuplicateReceipts = bool.Parse(dr["CanPrintDuplicateReceipts"].ToString()); TheDCCollector.OfficeID = int.Parse(dr["OfficeID"].ToString()); TheDCCollector.OfficeName = dr["OfficeName"].ToString(); TheDCCollector.AddedBy = int.Parse(dr["AddedBy"].ToString()); TheDCCollector.DateAdded = DateTime.Parse(dr["DateAdded"].ToString()).ToString(MicroConstants.DateFormat); return(TheDCCollector); }
public static int DeleteDCCollector(DCCollector theDCCollector) { return(DCCollectorDataAccess.GetInstance.DeleteDCCollector(theDCCollector)); }
public static int InsertDCCollector(DCCollector theDCCollector) { return(DCCollectorDataAccess.GetInstance.InsertDCCollector(theDCCollector)); }