public async Task DeleteFieldForceAsync()
{
FieldForceAddress address = new FieldForceAddress()
{
AddressLine1 = "7101 Richmond Hwy", AddressLine2 = "Apt 2", State = "VA", Zip = "22306", City = "Alexandria", CreatedBy = "Unit Test"
};
FieldForce fieldForce = new FieldForce()
{
Address = address, Code = "F1", Email = "*****@*****.**", Name = "Faisal AHmed", Phone = "(571)-409-8511", CreatedBy = "Unit Test"
};
UnitOfWork.FieldForces.Add(fieldForce);
await UnitOfWork.CompleteAsync();
FieldForce dbFieldForce = await UnitOfWork.FieldForces.GetAsync(fieldForce.Id);
Assert.IsNotNull(dbFieldForce);
UnitOfWork.FieldForces.Remove(dbFieldForce);
await UnitOfWork.CompleteAsync();
dbFieldForce = await UnitOfWork.FieldForces.GetAsync(fieldForce.Id);
Assert.IsNull(dbFieldForce);
}
public void InsertFieldForce()
{
FieldForceAddress address = new FieldForceAddress()
{
AddressLine1 = "7101 Richmond Hwy", AddressLine2 = "Apt 2", State = "VA", Zip = "22306", City = "Alexandria", CreatedBy = "Unit Test"
};
FieldForce fieldForce = new FieldForce()
{
Address = address, Code = "F1", Email = "*****@*****.**", Name = "Faisal AHmed", Phone = "(571)-409-8511", CreatedBy = "Unit Test"
};
UnitOfWork.FieldForces.Add(fieldForce);
UnitOfWork.Complete();
FieldForce dbFieldForce = UnitOfWork.FieldForces.Get(fieldForce.Id);
Assert.IsNotNull(dbFieldForce);
Assert.AreEqual(dbFieldForce.Name, fieldForce.Name);
Assert.AreEqual(dbFieldForce.Code, fieldForce.Code);
Assert.AreEqual(dbFieldForce.Email, fieldForce.Email);
Assert.AreEqual(dbFieldForce.Phone, fieldForce.Phone);
Assert.IsNotNull(dbFieldForce.Address);
}
public async Task InsertDistributorWithFieldForceAsync()
{
Distributor distributor = new Distributor()
{
Address = "9420 Key West Avenue", CreatedBy = "Unit Test", Code = "D1", Name = "DrFirst"
};
FieldForce fieldForce = new FieldForce()
{
Code = "F1", CreatedBy = "Unit Test", Address = new FieldForceAddress()
{
AddressLine1 = "7101 Richmond Hwy", CreatedBy = "Unit Test", City = "Alexandria", State = "VA", Zip = "22306", AddressLine2 = "Apt 2"
}, Name = "Faisal Ahmed", Phone = "571-409-8588"
};
distributor.FieldForces.Add(fieldForce);
UnitOfWork.Distributors.Add(distributor);
await UnitOfWork.CompleteAsync();
Distributor dbDistributor = UnitOfWork.Distributors.Get(distributor.Id);
Assert.IsNotNull(dbDistributor);
Assert.AreEqual(distributor.Code, dbDistributor.Code);
Assert.AreEqual(distributor.Name, dbDistributor.Name);
Assert.IsTrue(dbDistributor.FieldForces.Count > 0);
Assert.AreEqual(dbDistributor.FieldForces[0].Code, fieldForce.Code);
Assert.AreEqual(dbDistributor.FieldForces[0].Name, fieldForce.Name);
}
public void BindFieldForceList(List <FieldForce> theFieldForceList)
{
//ddl_MultiColumn.Items.Clear();
ddl_MultiColumn.DataSource = null;
ddl_MultiColumn.DataBind();
PageVariables.ValueForSelectedText = 3;
PageVariables.TheFieldForceList = theFieldForceList;
List <FieldForce> newfieldforcelist = new List <FieldForce>();
foreach (FieldForce NewFieldForce in theFieldForceList)
{
FieldForce newfieldforce = new FieldForce();
TextBox t1 = new TextBox();
t1.Text = AlignLeft(NewFieldForce.FieldForceName, PageVariables.FirstFieldLength) + " | " + AlignLeft(NewFieldForce.FieldForceCode, PageVariables.SecondFieldLength);
newfieldforce.FieldForceID = NewFieldForce.FieldForceID;
newfieldforce.FieldForceName = t1.Text;
newfieldforcelist.Add(newfieldforce);
}
//
ddl_MultiColumn.DataSource = newfieldforcelist;
ddl_MultiColumn.DataTextField = FieldForceManagement.GetInstance.DisplayMember;
ddl_MultiColumn.DataValueField = FieldForceManagement.GetInstance.ValueMember;
ddl_MultiColumn.DataBind();
ddl_MultiColumn.Items.Insert(0, new ListItem(MicroConstants.DROPDOWNLIST_DEFAULT_ITEMTEXT));
}
public static FieldForce GetFieldForceById(int recordId)
{
DataRow FieldForceRow = FieldForceDataAccess.GetInstance.GetFieldForceById(recordId);
FieldForce TheFieldForce = DataRowToObject(FieldForceRow);
return(TheFieldForce);
}
public async Task <int> DeleteAsync(int id)
{
FieldForce fieldforce = await _unitOfWork.FieldForces.GetAsync(id);
if (fieldforce == null)
{
throw new Exception("Invalid Fieldforce Id");
}
_unitOfWork.FieldForces.Remove(fieldforce);
return(await _unitOfWork.CompleteAsync());
}
private void PopulateLoggedOnUserInformation()
{
User TheLoggedOnUser = Micro.Commons.Connection.LoggedOnUser;
string UserName, FullName, Designation, Location;
UserName = MicroConstants.LABEL_DEFAULT_TEXT;
FullName = MicroConstants.LABEL_DEFAULT_TEXT;
Designation = MicroConstants.LABEL_DEFAULT_TEXT;
Location = MicroConstants.LABEL_DEFAULT_TEXT;
if (TheLoggedOnUser == null)
{
// DO NOTHING
// REDIRECT TO LOGIN PAGE
}
else
{
//TheLoggedOnUser = (User)Session["CurrentUser"];
UserName = String.Format("{0} ({1})", TheLoggedOnUser.UserName, TheLoggedOnUser.RoleDescription);
FullName = TheLoggedOnUser.UserReferenceName;
if (TheLoggedOnUser.UserType == MicroEnums.UserType.FieldForce.GetStringValue())
{
FieldForce f = FieldForceManagement.GetInstance.GetFieldForceById(TheLoggedOnUser.UserReferenceID);
Designation = f.FieldForceRankDescription;
Location = f.OfficeName;
}
else if (TheLoggedOnUser.UserType == MicroEnums.UserType.Employee.GetStringValue())
{
Employee emp = EmployeeManagement.GetInstance.GetEmployeeByID(TheLoggedOnUser.UserReferenceID);
Designation = emp.DesignationDescription;
Location = emp.OfficeName;
}
lbl_UserNameValue.Text = UserName.ToUpper();
lbl_FullNameValue.Text = FullName.ToUpper();
lbl_DesignationValue.Text = Helpers.ToCapitalize(Designation);
lbl_OfficeValue.Text = Location;
//List<Office> TheOfficeList = Micro.BusinessLayer.Administration.OfficeManagement.GetInstance.GetOfficeTreeByUserID(TheLoggedOnUser.UserID);
//if (TheOfficeList != null)
//{
// if (TheOfficeList.Count > 0)
// {
// lbl_OfficeValue.Text = String.Format("{0} / {1}", TheOfficeList[0].OfficeName, TheOfficeList[0].ParentOfficeName);
// }
//}
}
#endregion
}
public static List <FieldForce> GetFieldForceChainByFieldForceID(int fieldForceID)
{
List <FieldForce> FieldForceList = new List <FieldForce>();
DataTable FieldForceTable = FieldForceDataAccess.GetInstance.GetFieldForceChainByFieldForceID(fieldForceID);
foreach (DataRow dr in FieldForceTable.Rows)
{
FieldForce TheFieldForce = DataRowToObject(dr);
FieldForceList.Add(TheFieldForce);
}
return(FieldForceList);
}
public static List <FieldForce> GetFieldForceList(bool allOffices = false, bool showDeleted = false)
{
List <FieldForce> FieldForceList = new List <FieldForce>();
DataTable GetFieldForce = FieldForceDataAccess.GetInstance.GetFieldForceList(allOffices, showDeleted);
foreach (DataRow dr in GetFieldForce.Rows)
{
FieldForce TheFieldForce = DataRowToObject(dr);
FieldForceList.Add(TheFieldForce);
}
return(FieldForceList);
}
public static List <FieldForce> GetFieldForceByFieldForceRankID(int fieldForceRankID = 0, bool allOffices = false)
{
List <FieldForce> FieldForceList = new List <FieldForce>();
DataTable FieldForceTable = FieldForceDataAccess.GetInstance.GetFieldForceByFieldForceRankID(fieldForceRankID, allOffices);
foreach (DataRow dr in FieldForceTable.Rows)
{
FieldForce TheFieldForce = DataRowToObject(dr);
FieldForceList.Add(TheFieldForce);
}
return(FieldForceList);
}
public static FieldForce GetFieldForceByCode(string fieldForceCode)
{
FieldForce TheFieldForce;
DataRow FieldForceRow = FieldForceDataAccess.GetInstance.GetFieldForceByCode(fieldForceCode);
if (FieldForceRow != null)
{
TheFieldForce = DataRowToObject(FieldForceRow);
}
else
{
TheFieldForce = new FieldForce();
}
return(TheFieldForce);
}
public async Task <IHttpActionResult> GetFieldForceAsync(int id)
{
try
{
FieldForce ff = await _unitOfWork.FieldForces.GetAsync(id);
if (ff == null)
{
_logger.Info(string.Format("No fieldforce found with id", id));
return(NotFound());
}
return(Ok(new FieldForceDto()
{
Id = ff.Id,
Code = ff.Code,
Name = ff.Name,
AddressLine1 = ff.Address != null ? ff.Address.AddressLine1 : string.Empty,
AddressLine2 = ff.Address != null ? ff.Address.AddressLine2 : string.Empty,
City = ff.Address != null ? ff.Address.City : string.Empty,
State = ff.Address != null ? ff.Address.State : string.Empty,
Zip = ff.Address != null ? ff.Address.Zip : string.Empty,
Email = ff.Email,
Phone = ff.Phone,
MarketHierarchyId = ff.MarketHierarchyId,
MarketHierarchy = ff.MarketHierarchy != null ? new MarketHierarchyDto()
{
Code = ff.MarketHierarchy.Code, Name = ff.MarketHierarchy.Name, Id = ff.MarketHierarchy.Id, ParentId = ff.MarketHierarchy.ParentId, Type = ff.MarketHierarchy.Type
} : null,
Distributors = ff.Distributors != null ? ff.Distributors.Select(d => new DistributorDto()
{
Id = d.Id, Code = d.Code, Address = d.Address, Name = d.Name
}).ToList() : new List <DistributorDto>(),
DistributorIds = ff.Distributors != null ? ff.Distributors.Select(d => d.Id).ToList() : new List <int>()
}));
}
catch (Exception ex)
{
if (_logger.IsDebugEnabled)
{
_logger.Debug(ex);
return(InternalServerError(ex));
}
return(InternalServerError());
}
}
public int UpdateFieldForceChain(FieldForce theFieldForce)
{
int ReturnValue = 0;
using (SqlCommand InsertCommand = new SqlCommand())
{
InsertCommand.CommandType = CommandType.StoredProcedure;
InsertCommand.Parameters.Add(GetParameter("@FieldForceID", SqlDbType.Int, theFieldForce.FieldForceID));
InsertCommand.Parameters.Add(GetParameter("@ReportingToFieldForceID", SqlDbType.Int, theFieldForce.ReportingToFieldForceID));
InsertCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
InsertCommand.CommandText = "pCRM_FieldForceChains_UpdateChainSetting";
ExecuteStoredProcedure(InsertCommand);
ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public int DeleteFieldForce(FieldForce theFieldForce)
{
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("@FieldForceID", SqlDbType.Int, theFieldForce.FieldForceID));
DeleteCommand.Parameters.Add(GetParameter("@ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
DeleteCommand.CommandText = "pCRM_FieldForces_Delete";
ExecuteStoredProcedure(DeleteCommand);
ReturnValue = int.Parse(DeleteCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public int InsertFieldForceChain(FieldForce theFieldForce)
{
int ReturnValue = 0;
using (SqlCommand InsertCommand = new SqlCommand())
{
InsertCommand.CommandType = CommandType.StoredProcedure;
InsertCommand.Parameters.Add(GetParameter("@ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
InsertCommand.Parameters.Add(GetParameter("@FieldForceID", SqlDbType.Int, theFieldForce.FieldForceID));
InsertCommand.Parameters.Add(GetParameter("@ReportingToFieldForceID", SqlDbType.Int, theFieldForce.ReportingToFieldForceID));
InsertCommand.Parameters.Add(GetParameter("@OfficeID", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.OfficeID));
InsertCommand.Parameters.Add(GetParameter("@AddedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
InsertCommand.CommandText = "pCRM_FieldForceChains_Insert";
ExecuteStoredProcedure(InsertCommand);
ReturnValue = int.Parse(InsertCommand.Parameters[0].Value.ToString());
}
return(ReturnValue);
}
private void PopulateFieldForce(int fieldForceID)
{
FieldForce TheFieldForce = FieldForceManagement.GetInstance.GetFieldForceById(fieldForceID);
ddl_FieldForceSalutation.Text = TheFieldForce.Salutation;
txt_FieldForceName.Text = TheFieldForce.FieldForceName;
txt_FieldForceFatherName.Text = TheFieldForce.FatherName;
txt_fieldForceDateOfBirth.Text = DateTime.Parse(TheFieldForce.DateOfBirth).ToString(MicroConstants.DateFormat);
ddl_FieldForceGender.Text = TheFieldForce.Gender;
ddl_FieldForceReligion.Text = TheFieldForce.Religion;
ddl_FieldForceNationality.Text = TheFieldForce.Nationality;
ddl_FieldForceMaritalStatus.Text = TheFieldForce.MaritalStatus;
txt_FieldForcePresentTownOrCity.Text = TheFieldForce.Address_Present_TownOrCity;
ddl_FieldForcePresentDistrict.SelectedValue = TheFieldForce.Address_Present_DistrictID.ToString();
txt_FieldForcePresentState.Text = TheFieldForce.Address_Present_StateName;
txt_FieldForcePresentCountry.Text = TheFieldForce.Address_Present_CountryName;
txt_FieldForcePermanentTownOrCity.Text = TheFieldForce.Address_Permanent_TownOrCity;
ddl_FieldForcePermanentDistrict.SelectedValue = TheFieldForce.Address_Permanent_DistrictID.ToString();
txt_FieldForcePermanentState.Text = TheFieldForce.Address_Permanent_StateName;
txt_FieldForcePermanentCountry.Text = TheFieldForce.Address_Permanent_CountryName;
txt_FieldForcePhoneNumber.Text = TheFieldForce.PhoneNumber;
txt_FieldForceMobile.Text = TheFieldForce.Mobile;
}
public async Task <IHttpActionResult> SaveFieldForceAsync(FieldForceDto record)
{
FieldForce fieldforce = null;
MarketHierarchy market = null;
FieldForceAddress address = null;
List <Distributor> distributors = new List <Distributor>();
if (ModelState.IsValid)
{
try
{
if (record == null)
{
return(BadRequest());
}
if (record.MarketHierarchyId.HasValue)
{
market = await _unitOfWork.MarketHierarchies.GetAsync(record.MarketHierarchyId.Value);
if (market == null)
{
return(BadRequest("Invalid market id"));
}
}
foreach (int id in record.DistributorIds)
{
Distributor distributor = _unitOfWork.Distributors.Get(id);
if (distributor == null)
{
return(BadRequest("Invalid fistributor id"));
}
distributors.Add(distributor);
}
if (record.Id != null)
{
fieldforce = _unitOfWork.FieldForces.Get(record.Id.Value);
if (fieldforce == null)
{
return(NotFound());
}
fieldforce.UpdatedBy = "web:api";
fieldforce.UpdatedDate = DateTime.Now;
}
else
{
fieldforce = new FieldForce();
_unitOfWork.FieldForces.Add(fieldforce);
fieldforce.CreatedBy = "web:api";
}
fieldforce.Distributors.Clear();
fieldforce.Distributors = distributors;
fieldforce.MarketHierarchy = market;
fieldforce.Code = record.Code;
fieldforce.Name = record.Name;
fieldforce.Email = record.Email;
fieldforce.Phone = record.Phone;
address = new FieldForceAddress();
address.AddressLine1 = record.AddressLine1;
address.AddressLine2 = record.AddressLine2;
address.City = record.City;
address.State = record.State;
address.Zip = record.Zip;
await _unitOfWork.CompleteAsync();
return(Ok(new { status = "success" }));
}
catch (Exception ex)
{
if (_logger.IsDebugEnabled)
{
_logger.Debug(ex);
return(InternalServerError(ex));
}
return(InternalServerError());
}
}
else
{
return(BadRequest(ModelState));
}
}
public int UpdateFieldForce(FieldForce theFieldForce, FieldForceProfile thePhoto, FieldForceProfile theSignature)
{
return FieldForceIntegration.UpdateFieldForce(theFieldForce, thePhoto, theSignature);
}
public static int DeleteFieldForce(FieldForce theFieldForce)
{
return(FieldForceDataAccess.GetInstance.DeleteFieldForce(theFieldForce));
}
public static int UpdateFieldForce(FieldForce theFieldForce, FieldForceProfile thePhoto, FieldForceProfile theSignature)
{
return(FieldForceDataAccess.GetInstance.UpdateFieldForce(theFieldForce, thePhoto, theSignature));
}
public async Task <int> SaveAsync(FieldForceViewModel record)
{
FieldForce fieldForce = null;
FieldForceAddress address = null;
if (record.Id != null)
{
fieldForce = await _unitOfWork.FieldForces.GetAsync(record.Id.Value);
if (fieldForce == null)
{
throw new Exception("Invalid Fieldforce Id");
}
fieldForce.UpdatedBy = System.Web.HttpContext.Current.User.Identity.Name;
fieldForce.UpdatedDate = DateTime.Now;
address = fieldForce.Address;
}
else
{
fieldForce = new FieldForce();
fieldForce.CreatedBy = System.Web.HttpContext.Current.User.Identity.Name;
}
if (address == null)
{
address = new FieldForceAddress();
address.CreatedBy = System.Web.HttpContext.Current.User.Identity.Name;
}
else
{
address.UpdatedBy = System.Web.HttpContext.Current.User.Identity.Name;
address.UpdatedDate = DateTime.Today;
}
fieldForce.Code = record.Code;
fieldForce.Name = record.Name;
fieldForce.Email = record.Email;
fieldForce.Phone = record.Phone;
address.AddressLine1 = record.AddressLine1;
address.AddressLine2 = record.AddressLine2;
address.City = record.City;
address.State = record.State;
address.Zip = record.ZipCode;
fieldForce.Address = address;
fieldForce.MarketHierarchyId = record.MarketHierarchyId;
if (fieldForce.Distributors != null)
{
fieldForce.Distributors.Clear();
}
else
{
fieldForce.Distributors = new List <Distributor>();
}
if (record.DistributorIds != null && record.DistributorIds.Count > 0)
{
foreach (int id in record.DistributorIds)
{
Distributor distributor = _unitOfWork.Distributors.Get(id);
if (distributor != null)
{
fieldForce.Distributors.Add(distributor);
}
}
}
if (fieldForce.Id <= 0)
{
_unitOfWork.FieldForces.Add(fieldForce);
}
return(await _unitOfWork.CompleteAsync());
}
public static int UpdateFieldForceChain(FieldForce theFieldForce)
{
return(FieldForceChainDataAccess.GetInstance.UpdateFieldForceChain(theFieldForce));
}
public int UpdateFieldForceChain(FieldForce theFieldForce)
{
return(FieldForceChainIntegration.UpdateFieldForceChain(theFieldForce));
}
public int DeleteFieldForce(FieldForce theFieldForce)
{
return FieldForceIntegration.DeleteFieldForce(theFieldForce);
}
public void InsertFieldForceWithDistributorAndMarketHierarchy()
{
MarketHierarchy nation = new MarketHierarchy()
{
Code = "M1", CreatedBy = "Unit Test", Name = "US", Type = MarketHierarchyType.Nation
};
MarketHierarchy region = new MarketHierarchy()
{
Code = "M2", CreatedBy = "Unit Test", Name = "Virginia", Type = MarketHierarchyType.Region, Parent = nation
};
MarketHierarchy territory = new MarketHierarchy()
{
Code = "M3", CreatedBy = "Unit Test", Name = "Alexandria", Type = MarketHierarchyType.Territory, Parent = region
};
MarketHierarchy route = new MarketHierarchy()
{
Code = "M4", CreatedBy = "Unit Test", Name = "Richmond Hwy", Type = MarketHierarchyType.Route, Parent = territory
};
Distributor distributor = new Distributor()
{
Address = "9420 Key West Avenue", CreatedBy = "Unit Test", Code = "D1", Name = "DrFirst"
};
FieldForceAddress address = new FieldForceAddress()
{
AddressLine1 = "7101 Richmond Hwy", AddressLine2 = "Apt 2", State = "VA", Zip = "22306", City = "Alexandria", CreatedBy = "Unit Test"
};
FieldForce fieldForce = new FieldForce()
{
Address = address, Code = "F1", Email = "*****@*****.**", Name = "Faisal AHmed", Phone = "(571)-409-8511", CreatedBy = "Unit Test"
};
fieldForce.MarketHierarchy = route;
fieldForce.Distributors.Add(distributor);
UnitOfWork.MarketHierarchies.Add(route);
UnitOfWork.MarketHierarchies.Add(territory);
UnitOfWork.MarketHierarchies.Add(region);
UnitOfWork.MarketHierarchies.Add(nation);
UnitOfWork.Distributors.Add(distributor);
UnitOfWork.FieldForces.Add(fieldForce);
UnitOfWork.Complete();
FieldForce dbFieldForce = UnitOfWork.FieldForces.Get(fieldForce.Id);
Assert.IsNotNull(dbFieldForce);
Assert.AreEqual(dbFieldForce.Name, fieldForce.Name);
Assert.AreEqual(dbFieldForce.Code, fieldForce.Code);
Assert.AreEqual(dbFieldForce.Email, fieldForce.Email);
Assert.AreEqual(dbFieldForce.Phone, fieldForce.Phone);
Assert.IsNotNull(dbFieldForce.MarketHierarchy);
Assert.AreEqual(dbFieldForce.MarketHierarchy.Id, route.Id);
Assert.AreEqual(dbFieldForce.MarketHierarchy.Code, route.Code);
Assert.AreEqual(dbFieldForce.MarketHierarchy.Name, route.Name);
Assert.AreEqual(1, dbFieldForce.Distributors.Count);
Assert.IsNotNull(dbFieldForce.Distributors[0]);
Assert.AreEqual(dbFieldForce.Distributors[0].Id, distributor.Id);
Assert.AreEqual(dbFieldForce.Distributors[0].Name, distributor.Name);
Assert.AreEqual(dbFieldForce.Distributors[0].Name, distributor.Name);
}
public int UpdateFieldForce(FieldForce theFieldForce, FieldForceProfile thePhoto, FieldForceProfile theSignature)
{
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("@FieldForceID", SqlDbType.Int, theFieldForce.FieldForceID));
UpdateCommand.Parameters.Add(GetParameter("@FieldForceRankID", SqlDbType.Int, theFieldForce.FieldForceRankID));
UpdateCommand.Parameters.Add(GetParameter("@FieldForceRankDescription", SqlDbType.VarChar, theFieldForce.FieldForceRankDescription));
UpdateCommand.Parameters.Add(GetParameter("@ReportingToFieldForceID", SqlDbType.Int, theFieldForce.ReportingToFieldForceID));
UpdateCommand.Parameters.Add(GetParameter("@Salutation", SqlDbType.VarChar, theFieldForce.Salutation));
UpdateCommand.Parameters.Add(GetParameter("@FieldForceName", SqlDbType.VarChar, theFieldForce.FieldForceName));
UpdateCommand.Parameters.Add(GetParameter("@FatherName", SqlDbType.VarChar, theFieldForce.FatherName));
UpdateCommand.Parameters.Add(GetParameter("@HusbandName", SqlDbType.VarChar, theFieldForce.HusbandName));
UpdateCommand.Parameters.Add(GetParameter("@Gender", SqlDbType.VarChar, theFieldForce.Gender));
UpdateCommand.Parameters.Add(GetParameter("@MaritalStatus", SqlDbType.VarChar, theFieldForce.MaritalStatus));
UpdateCommand.Parameters.Add(GetParameter("@DateOfBirth", SqlDbType.VarChar, theFieldForce.DateOfBirth));
UpdateCommand.Parameters.Add(GetParameter("@Age", SqlDbType.Int, theFieldForce.Age));
UpdateCommand.Parameters.Add(GetParameter("@Address_Present_TownOrCity", SqlDbType.VarChar, theFieldForce.Address_Present_TownOrCity));
UpdateCommand.Parameters.Add(GetParameter("@Address_Present_Landmark", SqlDbType.VarChar, theFieldForce.Address_Present_Landmark));
UpdateCommand.Parameters.Add(GetParameter("@Address_Present_PinCode", SqlDbType.VarChar, theFieldForce.Address_Present_PinCode));
UpdateCommand.Parameters.Add(GetParameter("@Address_Present_DistrictID", SqlDbType.Int, theFieldForce.Address_Present_DistrictID));
UpdateCommand.Parameters.Add(GetParameter("@Address_Permanent_TownOrCity", SqlDbType.VarChar, theFieldForce.Address_Permanent_TownOrCity));
UpdateCommand.Parameters.Add(GetParameter("@Address_Permanent_Landmark", SqlDbType.VarChar, theFieldForce.Address_Permanent_Landmark));
UpdateCommand.Parameters.Add(GetParameter("@Address_Permanent_PinCode", SqlDbType.VarChar, theFieldForce.Address_Permanent_PinCode));
UpdateCommand.Parameters.Add(GetParameter("@Address_Permanent_DistrictID", SqlDbType.Int, theFieldForce.Address_Permanent_DistrictID));
UpdateCommand.Parameters.Add(GetParameter("@PhoneNumber", SqlDbType.VarChar, theFieldForce.PhoneNumber));
UpdateCommand.Parameters.Add(GetParameter("@Mobile", SqlDbType.VarChar, theFieldForce.Mobile));
UpdateCommand.Parameters.Add(GetParameter("@EMailID", SqlDbType.VarChar, theFieldForce.EMailID));
UpdateCommand.Parameters.Add(GetParameter("@FieldForce_Qualification", SqlDbType.VarChar, theFieldForce.FieldForce_Qualification));
UpdateCommand.Parameters.Add(GetParameter("@Occupation", SqlDbType.VarChar, theFieldForce.Occupation));
UpdateCommand.Parameters.Add(GetParameter("@Nationality", SqlDbType.VarChar, theFieldForce.Nationality));
UpdateCommand.Parameters.Add(GetParameter("@Religion", SqlDbType.VarChar, theFieldForce.Religion));
UpdateCommand.Parameters.Add(GetParameter("@Caste", SqlDbType.VarChar, theFieldForce.Caste));
UpdateCommand.Parameters.Add(GetParameter("@NomineeName", SqlDbType.VarChar, theFieldForce.NomineeName));
UpdateCommand.Parameters.Add(GetParameter("@Nominee_Permanent_TownOrCity", SqlDbType.VarChar, theFieldForce.Nominee_Permanent_TownOrCity));
UpdateCommand.Parameters.Add(GetParameter("@Nominee_Permanent_Landmark", SqlDbType.VarChar, theFieldForce.Nominee_Permanent_Landmark));
UpdateCommand.Parameters.Add(GetParameter("@Nominee_Permanent_PinCode", SqlDbType.VarChar, theFieldForce.Nominee_Permanent_PinCode));
UpdateCommand.Parameters.Add(GetParameter("@Nominee_Permanent_DistrictID", SqlDbType.Int, theFieldForce.Nominee_Permanent_DistrictID));
UpdateCommand.Parameters.Add(GetParameter("@NomineeRelationship", SqlDbType.VarChar, theFieldForce.NomineeRelationship));
UpdateCommand.Parameters.Add(GetParameter("@NomineeAge", SqlDbType.Int, theFieldForce.NomineeAge));
UpdateCommand.Parameters.Add(GetParameter("@IsNomineeACoWorker", SqlDbType.Bit, theFieldForce.IsNomineeACoWorker));
UpdateCommand.Parameters.Add(GetParameter("@Nominee_Qualification", SqlDbType.VarChar, theFieldForce.Nominee_Qualification));
UpdateCommand.Parameters.Add(GetParameter("@BankBranchID", SqlDbType.Int, theFieldForce.BankBranchID));
UpdateCommand.Parameters.Add(GetParameter("@BankAccountNumber", SqlDbType.VarChar, theFieldForce.BankAccountNumber));
UpdateCommand.Parameters.Add(GetParameter("@PhotoKeyName", SqlDbType.VarChar, thePhoto.SettingKeyName));
UpdateCommand.Parameters.Add(GetParameter("@PhotoKeyDescription", SqlDbType.VarChar, thePhoto.SettingKeyDescription));
UpdateCommand.Parameters.Add(GetParameter("@PhotoKeyValue", SqlDbType.VarBinary, thePhoto.SettingKeyValue));
UpdateCommand.Parameters.Add(GetParameter("@PhotoKeyReference", SqlDbType.VarChar, thePhoto.SettingKeyReference));
UpdateCommand.Parameters.Add(GetParameter("@SignatureKeyName", SqlDbType.VarChar, theSignature.SettingKeyName));
UpdateCommand.Parameters.Add(GetParameter("@SignatureKeyDescription", SqlDbType.VarChar, theSignature.SettingKeyDescription));
UpdateCommand.Parameters.Add(GetParameter("@SignatureKeyValue", SqlDbType.VarBinary, theSignature.SettingKeyValue));
UpdateCommand.Parameters.Add(GetParameter("@SignatureKeyReference", SqlDbType.VarChar, theSignature.SettingKeyReference));
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_FieldForces_Update";
ExecuteStoredProcedure(UpdateCommand);
ReturnValue = int.Parse(UpdateCommand.Parameters[0].Value.ToString());
return(ReturnValue);
}
}
public static FieldForce DataRowToObject(DataRow dr)
{
FieldForce TheFieldForce = new FieldForce();
TheFieldForce.FieldForceID = int.Parse(dr["FieldForceID"].ToString());
TheFieldForce.FieldForceCode = dr["FieldForceCode"].ToString();
TheFieldForce.FieldForceRankID = int.Parse(dr["FieldForceRankID"].ToString());
TheFieldForce.FieldForceRankName = dr["FieldForceRankName"].ToString();
TheFieldForce.FieldForceRankDescription = dr["FieldForceRankDescription"].ToString();
TheFieldForce.ReportingToFieldForceRankID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["ReportingToFieldForceRankID"].ToString()));
if (TheFieldForce.ReportingToFieldForceRankID > 0)
{
TheFieldForce.ReportingToFieldForceRankName = dr["ReportingToFieldForceRankName"].ToString();
TheFieldForce.ReportingToFieldForceRankDescription = dr["ReportingToFieldForceRankDescription"].ToString();
TheFieldForce.ReportingToFieldForceID = int.Parse(dr["ReportingToFieldForceID"].ToString());
TheFieldForce.ReportingToFieldForceCode = dr["ReportingToFieldForceCode"].ToString();
TheFieldForce.ReportingToFieldForceName = dr["ReportingToFieldForceName"].ToString();
}
TheFieldForce.Salutation = dr["Salutation"].ToString();
TheFieldForce.FieldForceName = dr["FieldForceName"].ToString();
TheFieldForce.FatherName = dr["FatherName"].ToString();
TheFieldForce.HusbandName = dr["HusbandName"].ToString();
TheFieldForce.Gender = dr["Gender"].ToString();
TheFieldForce.MaritalStatus = dr["MaritalStatus"].ToString();
TheFieldForce.DateOfBirth = DateTime.Parse(dr["DateOfBirth"].ToString()).ToString(MicroConstants.DateFormat);
TheFieldForce.Age = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["Age"].ToString()));
TheFieldForce.Address_Present_TownOrCity = dr["Address_Present_TownOrCity"].ToString();
TheFieldForce.Address_Present_Landmark = dr["Address_Present_Landmark"].ToString();
TheFieldForce.Address_Present_PinCode = dr["Address_Present_PinCode"].ToString();
TheFieldForce.Address_Present_DistrictID = int.Parse(dr["Address_Present_DistrictID"].ToString());
TheFieldForce.Address_Present_DistrictName = dr["Address_Present_DistrictName"].ToString();
TheFieldForce.Address_Present_StateName = dr["Address_Present_StateName"].ToString();
TheFieldForce.Address_Present_CountryName = dr["Address_Present_CountryName"].ToString();
TheFieldForce.Address_Permanent_TownOrCity = dr["Address_Permanent_TownOrCity"].ToString();
TheFieldForce.Address_Permanent_Landmark = dr["Address_Permanent_Landmark"].ToString();
TheFieldForce.Address_Permanent_PinCode = dr["Address_Permanent_PinCode"].ToString();
TheFieldForce.Address_Permanent_DistrictID = int.Parse(dr["Address_Permanent_DistrictID"].ToString());
TheFieldForce.Address_Permanent_DistrictName = dr["Address_Permanent_DistrictName"].ToString();
TheFieldForce.Address_Permanent_StateName = dr["Address_Permanent_StateName"].ToString();
TheFieldForce.Address_Permanent_CountryName = dr["Address_Permanent_CountryName"].ToString();
TheFieldForce.PhoneNumber = dr["PhoneNumber"].ToString();
TheFieldForce.Mobile = dr["Mobile"].ToString();
TheFieldForce.EMailID = dr["EMailID"].ToString();
TheFieldForce.FieldForce_Qualification = dr["FieldForce_Qualification"].ToString();
TheFieldForce.Occupation = dr["Occupation"].ToString();
TheFieldForce.Nationality = dr["Nationality"].ToString();
TheFieldForce.Religion = dr["Religion"].ToString();
TheFieldForce.Caste = dr["Caste"].ToString();
TheFieldForce.NomineeName = dr["NomineeName"].ToString();
TheFieldForce.Nominee_Permanent_TownOrCity = dr["Nominee_Permanent_TownOrCity"].ToString();
TheFieldForce.Nominee_Permanent_Landmark = dr["Nominee_Permanent_Landmark"].ToString();
TheFieldForce.Nominee_Permanent_PinCode = dr["Nominee_Permanent_PinCode"].ToString();
TheFieldForce.Nominee_Permanent_DistrictID = int.Parse(dr["Nominee_Permanent_DistrictID"].ToString());
TheFieldForce.Nominee_Permanent_DistrictName = dr["Nominee_Permanent_DistrictName"].ToString();
TheFieldForce.Nominee_Permanent_StateName = dr["Nominee_Permanent_StateName"].ToString();
TheFieldForce.Nominee_Permanent_CountryName = dr["Nominee_Permanent_CountryName"].ToString();
TheFieldForce.NomineeRelationship = dr["NomineeRelationship"].ToString();
TheFieldForce.NomineeAge = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["NomineeAge"].ToString()));
TheFieldForce.IsNomineeACoWorker = bool.Parse(dr["IsNomineeACoWorker"].ToString());
TheFieldForce.Nominee_Qualification = dr["Nominee_Qualification"].ToString();
TheFieldForce.BankBranchID = int.Parse(MicroGlobals.ReturnZeroIfNull(dr["BankBranchID"].ToString()));
if (TheFieldForce.BankBranchID > 0)
{
TheFieldForce.BankName = dr["BankName"].ToString();
TheFieldForce.BankBranchName = dr["BankBranchName"].ToString();
TheFieldForce.BankAccountNumber = dr["BankAccountNumber"].ToString();
}
TheFieldForce.HasServiceComplain = bool.Parse(dr["HasServiceComplain"].ToString());
TheFieldForce.OfficeID = int.Parse(dr["OfficeID"].ToString());
TheFieldForce.OfficeName = dr["OfficeName"].ToString();
return(TheFieldForce);
}
public int InsertFieldForceChain(FieldForce theFieldForce)
{
return(FieldForceChainIntegration.InsertFieldForceChain(theFieldForce));
}
