private void FillGafferMemberDetails(long nGafferID)
{
GafferMaster oclsGafferMaster = null;
DataTable dtGafferDetails = null;
try
{
oclsGafferMaster = new GafferMaster();
dtGafferDetails = oclsGafferMaster.GetGafferInformation(nGafferID);
if (dtGafferDetails != null && dtGafferDetails.Rows.Count > 0)
{
lblGafferID.Text = Convert.ToString(dtGafferDetails.Rows[0]["nGafferID"]);
txtGafferCode.Text = Convert.ToString(dtGafferDetails.Rows[0]["sGafferCode"]);
txtGafferName.Text = Convert.ToString(dtGafferDetails.Rows[0]["sGafferName"]);
txtGafferAbbrivation.Text = Convert.ToString(dtGafferDetails.Rows[0]["sGafferAbbrivation"]);
cmbGender.Text = Convert.ToString(dtGafferDetails.Rows[0]["sGender"]);
dtGafferBirthdate.EditValue = Convert.ToDateTime(dtGafferDetails.Rows[0]["dtDOB"]);
txtGafferAge.Text = Convert.ToString(dtGafferDetails.Rows[0]["sAge"]);
txtAddressLine1.Text = Convert.ToString(dtGafferDetails.Rows[0]["sAddressLine1"]);
txtAddressLine2.Text = Convert.ToString(dtGafferDetails.Rows[0]["sAddressLine2"]);
txtCity.Text = Convert.ToString(dtGafferDetails.Rows[0]["sCity"]);
txtState.Text = Convert.ToString(dtGafferDetails.Rows[0]["sState"]);
txtCountry.Text = Convert.ToString(dtGafferDetails.Rows[0]["sCountry"]);
txtPincode.Text = Convert.ToString(dtGafferDetails.Rows[0]["sPincode"]);
txtEmail.Text = Convert.ToString(dtGafferDetails.Rows[0]["sEmail"]);
txtGafferUserName.Text = Convert.ToString(dtGafferDetails.Rows[0]["sLoginName"]);
txtGafferPin.Text = Convert.ToString(dtGafferDetails.Rows[0]["sLoginPin"]);
txtGafferPassword.Text = Convert.ToString(dtGafferDetails.Rows[0]["sPassword"]);
txtGafferConfirmPassword.Text = Convert.ToString(dtGafferDetails.Rows[0]["sPassword"]);
string[] sPhoneAll = Convert.ToString(dtGafferDetails.Rows[0]["sPhoneNo"]).Split(',');
if (sPhoneAll.Length > 0)
{
int nCompPanelCount = GetPanelCount(sPhoneAll.Length);
for (int i = 0; i < nCompPanelCount; i++)
{
ShowHidePhonePanel(sPhoneAll[i], i + 1);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.ToString(), clsGlobal._sMessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void FillGafferMasterList()
{
GafferMaster clsGafferMaster = null;
DataTable dt = null;
try
{
clsGafferMaster = new GafferMaster();
dt = clsGafferMaster.GetGafferlist(0);
if (dt != null)
{
gvGafferList.GridControl.DataSource = dt;
gvGafferList.Columns[1].Visible = false;
gvGafferList.Columns[8].Visible = false;
}
}
catch (Exception ex)
{
throw;
}
}
private void SaveGafferMember()
{
GafferMaster oclsGafferMaster = null;
try
{
string sPhone1 = Convert.ToString(txtPhone1.Text.Trim());
string sPhone2 = Convert.ToString(txtPhone4.Text.Trim());
string sPhone3 = Convert.ToString(txtPhone5.Text.Trim());
string sPhone4 = Convert.ToString(txtPhone3.Text.Trim());
string sPhone5 = Convert.ToString(txtPhone2.Text.Trim());
string sPhoneAll = string.Empty;
if (sPhone1 != "")
{
sPhoneAll += sPhone1;
}
if (sPhone2 != "")
{
sPhoneAll += "," + sPhone2;
}
if (sPhone3 != "")
{
sPhoneAll += "," + sPhone3;
}
if (sPhone4 != "")
{
sPhoneAll += "," + sPhone4;
}
if (sPhone5 != "")
{
sPhoneAll += "," + sPhone5;
}
oclsGafferMaster = new GafferMaster();
oclsGafferMaster.nGafferID = Convert.ToInt64(lblGafferID.Text);
oclsGafferMaster.sGafferName = Convert.ToString(txtGafferName.Text.Trim());
oclsGafferMaster.sGafferCode = Convert.ToString(txtGafferCode.Text.Trim());
oclsGafferMaster.sGafferAbbrivation = Convert.ToString(txtGafferAbbrivation.Text.Trim());
oclsGafferMaster.sGafferGender = Convert.ToString(cmbGender.Text.Trim());
oclsGafferMaster.dtGafferDOB = Convert.ToDateTime(dtGafferBirthdate.Text.Trim());
oclsGafferMaster.sGafferAge = Convert.ToString(txtGafferAge.Text.Trim());
oclsGafferMaster.sAddressLine1 = Convert.ToString(txtAddressLine1.Text.Trim());
oclsGafferMaster.sAddressLine2 = Convert.ToString(txtAddressLine2.Text.Trim());
oclsGafferMaster.sCity = Convert.ToString(txtCity.Text.Trim());
oclsGafferMaster.sState = Convert.ToString(txtState.Text.Trim());
oclsGafferMaster.sCountry = Convert.ToString(txtCountry.Text.Trim());
oclsGafferMaster.sPincode = Convert.ToString(txtPincode.Text.Trim());
oclsGafferMaster.sEmail = Convert.ToString(txtEmail.Text.Trim());
oclsGafferMaster.sAllPhoneNo = sPhoneAll;
oclsGafferMaster.sUserName = Convert.ToString(txtGafferUserName.Text.Trim());
oclsGafferMaster.sPassword = Convert.ToString(txtGafferConfirmPassword.Text.Trim());
oclsGafferMaster.sPin = Convert.ToString(txtGafferPin.Text.Trim());
Int64 nGafferMemberID = oclsGafferMaster.InsertUpdateGafferMaster();
if (nGafferMemberID != 0)
{
MessageBox.Show("Gaffer is saved successfully.", clsGlobal.MessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearForm();
}
else
{
MessageBox.Show("Error while saving gaffer.", clsGlobal.MessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.ToString(), clsGlobal._sMessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
