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