public int UpdateFieldForce(int fieldForceId)
{
int ProcReturnValue = 0;
UserProfileFieldForce TheFieldForce = new UserProfileFieldForce();
TheFieldForce.FieldForceID = Connection.LoggedOnUser.UserReferenceID;
TheFieldForce.Salutation = ddl_FieldForceSalutation.SelectedValue;
TheFieldForce.FieldForceName = txt_FieldForceName.Text;
TheFieldForce.FatherName = txt_FieldForceFatherName.Text;
TheFieldForce.DateOfBirth = DateTime.Parse(txt_fieldForceDateOfBirth.Text);
TheFieldForce.Gender = ddl_FieldForceGender.SelectedValue;
TheFieldForce.Religion = ddl_FieldForceReligion.SelectedValue;
TheFieldForce.Nationality = ddl_FieldForceNationality.SelectedValue;
TheFieldForce.MaritalStatus = ddl_FieldForceMaritalStatus.SelectedValue;
TheFieldForce.Address_Present_TownOrCity = txt_FieldForcePresentTownOrCity.Text;
TheFieldForce.Address_Present_DistrictID = int.Parse(ddl_FieldForcePresentDistrict.SelectedValue);
TheFieldForce.Address_Permanent_TownOrCity = txt_FieldForcePermanentTownOrCity.Text;
TheFieldForce.Address_Permanent_DistrictID = int.Parse(ddl_FieldForcePermanentDistrict.SelectedValue);
TheFieldForce.PhoneNumber = txt_FieldForcePhoneNumber.Text;
TheFieldForce.Mobile = txt_FieldForceMobile.Text;
//TODO: Add ProfilePhote & ProfileSignature
ProcReturnValue = UserProfileFieldForceManagement.GetInstance.UpdateUserProfileFieldForce(TheFieldForce);
return(ProcReturnValue);
}
public static int UpdateUserProfileFieldforce(UserProfileFieldForce theFieldforce)
{
try
{
return(UserProfileFieldForceDataAccess.GetInstance.UpdateUserProfileFieldForce(theFieldforce));
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
public int UpdateUserProfileFieldForce(UserProfileFieldForce theFieldForce)
{
try
{
int ReturnValue = 0;
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add(GetParameter("ReturnValue", SqlDbType.Int, ReturnValue)).Direction = ParameterDirection.Output;
sqlcmd.Parameters.Add(GetParameter("FieldForceID", SqlDbType.Int, theFieldForce.FieldForceID));
sqlcmd.Parameters.Add(GetParameter("Salutation", SqlDbType.VarChar, theFieldForce.Salutation));
sqlcmd.Parameters.Add(GetParameter("FieldForceName", SqlDbType.VarChar, theFieldForce.FieldForceName));
sqlcmd.Parameters.Add(GetParameter("FatherName", SqlDbType.VarChar, theFieldForce.FatherName));
sqlcmd.Parameters.Add(GetParameter("DateOfBirth", SqlDbType.DateTime, theFieldForce.DateOfBirth.ToString(MicroConstants.DateFormat)));
sqlcmd.Parameters.Add(GetParameter("Gender", SqlDbType.VarChar, theFieldForce.Gender));
sqlcmd.Parameters.Add(GetParameter("Religion", SqlDbType.VarChar, theFieldForce.Religion));
sqlcmd.Parameters.Add(GetParameter("Nationality", SqlDbType.VarChar, theFieldForce.Nationality));
sqlcmd.Parameters.Add(GetParameter("MaritalStatus", SqlDbType.VarChar, theFieldForce.MaritalStatus));
sqlcmd.Parameters.Add(GetParameter("Address_Present_TownOrCity", SqlDbType.VarChar, theFieldForce.Address_Present_TownOrCity));
sqlcmd.Parameters.Add(GetParameter("Address_Present_DistrictID", SqlDbType.Int, theFieldForce.Address_Present_DistrictID));
sqlcmd.Parameters.Add(GetParameter("Address_Permanent_TownOrCity", SqlDbType.VarChar, theFieldForce.Address_Permanent_TownOrCity));
sqlcmd.Parameters.Add(GetParameter("Address_Permanent_DistrictID", SqlDbType.Int, theFieldForce.Address_Permanent_DistrictID));
sqlcmd.Parameters.Add(GetParameter("PhoneNumber", SqlDbType.VarChar, theFieldForce.PhoneNumber));
sqlcmd.Parameters.Add(GetParameter("Mobile", SqlDbType.VarChar, theFieldForce.Mobile));
sqlcmd.Parameters.Add(GetParameter("ModifiedBy", SqlDbType.Int, Micro.Commons.Connection.LoggedOnUser.UserID));
sqlcmd.CommandText = "pCRM_UserProfile_FieldForce_Update";
ExecuteStoredProcedure(sqlcmd);
ReturnValue = int.Parse(sqlcmd.Parameters[0].Value.ToString());
return(ReturnValue);
}
catch (Exception ex)
{
throw (new Exception(MethodBase.GetCurrentMethod().DeclaringType.ToString() + "." + (new System.Diagnostics.StackFrame()).GetMethod().Name, ex));
}
}
