private void FillMajorCostNames()
{
string strCommand = "";
try
{
objSqlDB = new SQLDB();
strCommand = "SELECT MCC_MAJOR_COST_CENTRE_ID,MCC_MAJOR_COST_CENTRE_NAME FROM FA_MAJOR_COST_CENTRE where mcc_company_code='" + CommonData.CompanyCode + "'";
DataTable dtCCNameDetails = objSqlDB.ExecuteDataSet(strCommand).Tables[0];
UtilityLibrary.AutoCompleteTextBox(txtMajorCostCenterName, dtCCNameDetails, "", "MCC_MAJOR_COST_CENTRE_NAME");
objSqlDB = null;
strCommand = "";
objSqlDB = new SQLDB();
strCommand = "SELECT MCC_MAJOR_COST_CENTRE_ID,MCC_SHORT_NAME FROM FA_MAJOR_COST_CENTRE where mcc_company_code='" + CommonData.CompanyCode + "'";
DataTable dtCCSNameDetails = objSqlDB.ExecuteDataSet(strCommand).Tables[0];
UtilityLibrary.AutoCompleteTextBox(txtMajorCostCenterSName, dtCCSNameDetails, "", "MCC_SHORT_NAME");
objSqlDB = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objSqlDB = null;
}
}
private void MoveCharacter()
{
currentSpeed += direction * (accelerationRate * Time.fixedDeltaTime);
if (currentSpeed >= maxSpeed)
{
currentSpeed = maxSpeed;
}
else if (Mathf.Abs(currentSpeed) >= maxSpeed)
{
currentSpeed = (-1) * maxSpeed;
}
if (jump)
{
jumpIndex++;
}
//Debug.Log(currentSpeed);
rb.velocity = new Vector2((direction * walkSpeed) + currentSpeed, jump && jumpIndex <= jumpHeight.Count - 1 ? CalculateJumpSpeed() : rb.velocity.y);
if (UtilityLibrary.sign(direction) != UtilityLibrary.sign(currentSpeed) && currentSpeed != 0)
{
int currentSign = UtilityLibrary.sign(currentSpeed);
currentSpeed -= UtilityLibrary.sign(currentSpeed) * decelerationRate * Time.fixedDeltaTime;
if (currentSign != UtilityLibrary.sign(currentSpeed))
{
currentSpeed = 0;
}
}
if (jump)
{
jumpIndex++;
}
// Debug.Log(jumpIndex);
jump = false;
}
public ActionResult Patient([FromBody] int?usertype)
{
try
{
Session["UserTypeID"] = usertype;
int patientId = usertype == 2? (int)Session["UserID"]: UtilityLibrary.GetValueInt(Session["PatientID"], 0);
PatientModel model = new PatientModel();
if (usertype == (int)CommonUnit.UserType.Patient)
{
Patient result = _document.GetPatientById(patientId);
model = Mappings.MapPatient(result);
return(View("Patient", model));
}
else if (usertype == (int)CommonUnit.UserType.Staff)
{
return(View("Patient", model));
}
else
{
ViewBag.Error = "User type is invalid !";
return(RedirectToAction("Login", "Login", CommonUnit.UserType.Staff));
}
}
catch (Exception)
{
ViewBag.Error = "User type is invalid !";
return(RedirectToAction("Login", "Login", CommonUnit.UserType.Staff));
}
}
private void btnSave_Click(object sender, EventArgs e)
{
UtilityLibrary oUtility = new UtilityLibrary();
if (!SSCRM.App_Code.UtilityLibrary.CustomValidate(grouper1, toolTip1))
{
return;
}
//bellow line for delete the row in dtEducation table
if (drs != null)
{
((frmApplication)objApplication).dtECA.Rows.Remove(drs[0]);
}
//till here
DataView dv = ((frmApplication)objApplication).dtECA.DefaultView;
if (dv.Table.Rows.Count > 0)
{
dv.RowFilter = "TypeofECA='" + cmbTypeEC.Text + "'";
DataTable dt;
dt = dv.ToTable();
if (dt.Rows.Count > 0)
{
MessageBox.Show("This ECA Type is already exists", "SSCRM Application", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
((frmApplication)objApplication).dtECA.Rows.Add(new Object[] { "-1", cmbTypeEC.Text, txtRemarks.Text });
((frmApplication)objApplication).GetDGVECA();
this.Close();
}
private void OpeningBranchBalances_Load(object sender, EventArgs e)
{
cbCrDr.SelectedIndex = 0;
txtComanpanyName.Text = CommonData.CompanyName;
txtBranch.Text = CommonData.BranchName;
txtFinYear.Text = CommonData.FinancialYear;
startDate = new DateTime(Convert.ToInt32(txtFinYear.Text.Split('-')[0]), 4, 1);
SQLDB objDB = new SQLDB();
DataTable dtAccMas = objDB.ExecuteDataSet(" SELECT AM_ACCOUNT_ID,AM_ACCOUNT_NAME AccName FROM FA_ACCOUNT_MASTER WHERE AM_COMPANY_CODE='" + CommonData.CompanyCode +
"' AND AM_ACCOUNT_TYPE_ID IN('CASH','BANK') and AM_ACCOUNT_GROUP_ID IS NULL ").Tables[0];
UtilityLibrary.AutoCompleteComboBox(cmbAccounts, dtAccMas, "AM_ACCOUNT_ID", "AccName");
if (dtAccMas.Rows.Count > 0)
{
DataRow dr = dtAccMas.NewRow();
cmbAccounts.DataSource = dtAccMas;
cmbAccounts.DisplayMember = "AccName";
cmbAccounts.ValueMember = "AM_ACCOUNT_ID";
}
FillGrid();
FillDocMonths();
}
/// <summary>
/// Update Patient
/// </summary>
/// <param name="patient"></param>
/// <returns></returns>
public bool UpdatePatient(Patient patient)
{
try
{
using (IDbConnection cn = dbConnection)
{
int result = cn.Execute("UpdatePatient",
new
{
PatientId = patient.PatientId,
PatientName = UtilityLibrary.GetValueString(patient.PatientName),
NIC = UtilityLibrary.GetValueString(patient.NIC),
Gender = UtilityLibrary.GetValueString(patient.Gender),
Birthday = patient.Birthday,
UpdatedDate = patient.UpdatedDate,
IsActive = patient.IsActive
},
commandType: CommandType.StoredProcedure);
return(Convert.ToBoolean(result));
}
}
catch (Exception ex)
{
throw ex;
}
}
private void ProductInterval_Load(object sender, EventArgs e)
{
dtFromdate.Value = Convert.ToDateTime(CommonData.CurrentDate);
dtTodate.Value = Convert.ToDateTime(CommonData.CurrentDate);
objSecurity = new Security();
UtilityLibrary.PopulateControl(cbCompany, objSecurity.GetCompanyDataSet().Tables[0].DefaultView, 1, 0, "-- Please Select --", 0);
objSecurity = null;
lblCheckID.Text = "0";
btnDelete.Enabled = false;
if (dt.Columns.Count == 0)
{
dt.Columns.Add("FrmQty");
dt.Columns.Add("ToQty");
dt.Columns.Add("Rate");
dt.Columns.Add("Points");
}
if (CommonData.LogUserId.ToUpper() != "ADMIN")
{
cbCompany.SelectedValue = CommonData.CompanyCode;
cbCompany.Enabled = false;
cbBranch.SelectedValue = CommonData.BranchCode;
cbBranch.Enabled = false;
}
else
{
cbCompany.SelectedValue = CommonData.CompanyCode;
cbBranch.SelectedValue = CommonData.BranchCode;
}
}
private void cbCompany_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbCompany.SelectedIndex > 0)
{
objDB = new SQLDB();
try
{
DataTable dtBranch = objDB.ExecuteDataSet("SELECT branch_code as branch_code, branch_name as branch_name,branch_Type,ACTIVE FROM branch_mas " +
"WHERE branch_name<>'' AND BRANCH_TYPE='BR' AND upper(company_code)=Upper('" + cbCompany.SelectedValue.ToString() + "') Order by branch_name").Tables[0];
UtilityLibrary.PopulateControl(cbBranch, dtBranch.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objDB = null;
}
}
else
{
cbBranch.DataSource = null;
}
}
public async Task TestS3EventLambdaFunction()
{
// Invoke the lambda function and confirm the content type was returned.
var function = new Function();
var body = new Dictionary <string, string>();
body.Add(
"url",
"https://www.darkmattercoffee.com/products/giant-steps-1"
);
var bodyString = UtilityLibrary.Serialize(body);
var contentType = await function.FunctionHandler(
new CoffeeAPIGatewayRequest {
Body = bodyString,
HttpMethod = "POST",
Path = "/GetCoffeeDetailsFromURL"
},
null
);
Assert.IsType <LambdaProxyResponse>(contentType);
Console.WriteLine(contentType);
}
private void cbBranch_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbBranch.SelectedIndex > 0)
{
sType = "S";
objInvDB = new InvoiceDB();
try
{
DataTable dtStates = objInvDB.GetVillagesDdlForCustList(cbCompany.SelectedValue.ToString(), cbBranch.SelectedValue.ToString(), "", "", "", "", "", "", "", 0, 0, sType).Tables[0];
UtilityLibrary.PopulateControl(cbState, dtStates.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objInvDB = null;
}
}
else
{
sType = "";
cbState.DataSource = null;
}
}
private void frmReference_Load(object sender, EventArgs e)
{
this.Location = new Point(Screen.PrimaryScreen.WorkingArea.X + 300, Screen.PrimaryScreen.WorkingArea.Y + 200);
this.StartPosition = FormStartPosition.CenterScreen;
objSQLDB = new SQLDB();
string strSQL1 = "SELECT OM_OCCUPATION,OM_OCCUPATION FROM OCCUPATION_MASTER";
DataTable dt1 = objSQLDB.ExecuteDataSet(strSQL1, CommandType.Text).Tables[0];
UtilityLibrary.PopulateControl(cmbOccupation_optional, dt1.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
if (drs != null)
{
txtReference.Text = drs[0][1].ToString();
//txtrefOccu.Text = drs[0][2].ToString();
cmbOccupation_optional.Text = drs[0][2].ToString();
txtRefPhno_optional.Text = drs[0][3].ToString();
addressCtrl1.HouseNo = drs[0][4].ToString();
addressCtrl1.LandMark = drs[0][5].ToString();
addressCtrl1.Village = drs[0][6].ToString();
addressCtrl1.Mondal = drs[0][7].ToString();
addressCtrl1.District = drs[0][8].ToString();
addressCtrl1.State = drs[0][9].ToString();
addressCtrl1.Pin = drs[0][10].ToString();
txtPhoneno.Text = drs[0][11].ToString();
}
}
private void CamptoSP_Load(object sender, EventArgs e)
{
dtDocMon.Value = System.DateTime.Now;
DataView dvBranch = objSQLDB.ExecuteDataSet("SELECT BRANCH_CODE,BRANCH_NAME FROM BRANCH_MAS WHERE BRANCH_TYPE='BR' ORDER BY BRANCH_NAME").Tables[0].DefaultView;
UtilityLibrary.PopulateControl(cmbBranch, dvBranch, 1, 0, "--PLEASE SELECT--", 0);
}
private void FillDropDownControls()
{
objDB = new SQLDB();
try
{
DataTable dt = new DataTable();
dt = objDB.ExecuteDataSet("SELECT DISTINCT cast(DESIG_CODE as varchar)+'^'+cast(isnull(ldm_elevel_id,0) as varchar) " +
"DESIG_CODE,Desig_Name From DESIG_MAS left JOIN LevelsDesig_mas ON LDM_DESIG_ID " +
"= DESIG_CODE ORDER BY Desig_Name", CommandType.Text).Tables[0];
DataView dvDestDesg = dt.DefaultView;
DataView dvSourceDesg = objDB.ExecuteDataSet("SELECT DISTINCT cast(DESIG_CODE as varchar)+'^'+cast(isnull(ldm_elevel_id,0) as varchar) " +
"DESIG_CODE,Desig_Name From DESIG_MAS left JOIN LevelsDesig_mas ON LDM_DESIG_ID " +
"= DESIG_CODE ORDER BY Desig_Name", CommandType.Text).Tables[0].DefaultView;
UtilityLibrary.PopulateControl(cmbDestDesig, dvDestDesg, 1, 0, "--PLEASE SELECT--", 0);
UtilityLibrary.PopulateControl(cmbSourceDesig, dvSourceDesg, 1, 0, "--PLEASE SELECT--", 0);
dt = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objDB = null;
}
}
public void GetPopupdropDown()
{
objSecurity = new Security();
objDB = new SQLDB();
DataTable dtCpy = objDB.ExecuteDataSet("SELECT CM_Company_Code, CM_Company_Name FROM Company_Mas" +
" ORDER BY CM_Company_Name", CommandType.Text).Tables[0];
UtilityLibrary.PopulateControl(cmbCompany, dtCpy.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
objDB = null;
objDB = new SQLDB();
DataView dvDept = objDB.ExecuteDataSet("SELECT dept_code,dept_name FROM Dept_Mas order by dept_name asc", CommandType.Text).Tables[0].DefaultView;
UtilityLibrary.PopulateControl(cmbDepartMent, dvDept, 1, 0, "--PLEASE SELECT--", 0);
DataView dtRBranch = objDB.ExecuteDataSet("SELECT BRANCH_CODE,BRANCH_NAME FROM BRANCH_MAS ORDER BY BRANCH_NAME ASC", CommandType.Text).Tables[0].DefaultView;
UtilityLibrary.PopulateControl(cmbRepToBranch, dtRBranch, 1, 0, "--PLEASE SELECT--", 0);
objDB = null;
objMstr = new Master();
DataTable dtSalTypes = objMstr.GetHRSalStructureTypes().Tables[0];
UtilityLibrary.PopulateControl(cmbSalStrType, dtSalTypes.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
objMstr = null;
}
private void FillBranchData()
{
objSQLdb = new SQLDB();
try
{
DataTable dtUnits = objSQLdb.ExecuteDataSet("SELECT BRANCH_NAME,BRANCH_CODE FROM BRANCH_MAS " +
" WHERE ACTIVE='T' Order by BRANCH_NAME ").Tables[0];
UtilityLibrary.AutoCompleteComboBox(cbUnit, dtUnits, "", "BRANCH_NAME");
if (dtUnits.Rows.Count > 0)
{
DataRow dr = dtUnits.NewRow();
dr[0] = "ALL";
dr[1] = "ALL";
dtUnits.Rows.InsertAt(dr, 0);
cbUnit.DataSource = dtUnits;
cbUnit.DisplayMember = "BRANCH_NAME";
cbUnit.ValueMember = "BRANCH_CODE";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objSQLdb = null;
//dt = null;
}
}
/// <summary>
/// Get patient by PIN
/// </summary>
/// <param name="pin"></param>
/// <returns></returns>
public Patient GetPatient(string pin)
{
Patient patinet = null;
try
{
if (!string.IsNullOrWhiteSpace(pin))
{
response = ServiceHelper.GetPOSTResponse(
new Uri(SvcUrls.urlGetPatientByPIN), UtilityLibrary.GetValueString(pin));
}
if (response.HttpStatusCode == HttpStatusCode.OK)
{
patinet = JsonConvert.DeserializeObject <Patient>(response.ResponseMessage);
}
else
{
patinet = null;
}
return(patinet);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// validate login credentials of staff member
/// </summary>
/// <param name="credentials"></param>
/// <returns>StaffID</returns>
public int CheckStaffLogin(Credentials credentials)
{
try
{
string data = JsonConvert.SerializeObject(credentials);
response = ServiceHelper.GetPOSTResponse(
new Uri(SvcUrls.urlCheckStaffLogin), UtilityLibrary.GetValueString(data));
if (response.HttpStatusCode == HttpStatusCode.OK)
{
int resp = JsonConvert.DeserializeObject <int>(response.ResponseMessage);
if (resp > 0)
{
return(resp);
}
else
{
return(0);
}
}
else
{
throw new NullReferenceException();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void cbCompany_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbCompany.SelectedIndex > 0)
{
//if (CommonData.LogUserId.ToUpper() != "ADMIN")
//{
objHrInfo = new HRInfo();
DataTable dtBranch = objHrInfo.GetUserBranchList(CommonData.LogUserId, cbCompany.SelectedValue.ToString(), "BR", "").Tables[0];
UtilityLibrary.PopulateControl(cbUserBranch, dtBranch.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
objHrInfo = null;
//}
//else
//{
// objHrInfo = new HRInfo();
// DataTable dtBranch = objHrInfo.GetAllBranchList(cbCompany.SelectedValue.ToString(), "BR", "").Tables[0];
// UtilityLibrary.PopulateControl(cbUserBranch, dtBranch.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
// objHrInfo = null;
//}
}
else
{
cbUserBranch.Items.Clear();
}
FillDataToGrid();
}
/// <summary>
/// Get patient by PatientId or PIn
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public Patient GetPatientByAny(string value)
{
try
{
if (!string.IsNullOrWhiteSpace(value))
{
if (value.Length <= 10)
{
return(GetPatient(UtilityLibrary.GetValueInt(value, 0)));
}
else
{
return(GetPatient(value));
}
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
private void PrevEmployee_Load(object sender, EventArgs e)
{
objSQLDB = new SQLDB();
DataSet ds = objSQLDB.ExecuteDataSet("SELECT CM_COMPANY_CODE, CM_COMPANY_NAME FROM COMPANY_MAS WHERE ACTIVE='T'");
UtilityLibrary.PopulateControl(cmbCompany, ds.Tables[0].DefaultView, 1, 0, "-- Please Select --", 0);
DataView dvDept = objSQLDB.ExecuteDataSet("SELECT DEPT_CODE, DEPT_DESC FROM DEPT_MAS").Tables[0].DefaultView;
UtilityLibrary.PopulateControl(cmbDepartment, dvDept, 1, 0, "--PLEASE SELECT--", 0);
string strSQL1 = "SELECT HRSM_RECRUITMENT_SOURCE_CODE, HRSM_RECRUITMENT_SOURCE_NAME from HR_RECRUITMENT_SOURCE_MASTER";
DataTable dt1 = objSQLDB.ExecuteDataSet(strSQL1).Tables[0];
UtilityLibrary.PopulateControl(cmbRecSour, dt1.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
objSQLDB = null;
dtDoj.Value = Convert.ToDateTime(CommonData.CurrentDate);
if (iFormType == 2)
{
this.Text = "Agent Rejoin";
cmbCompany.SelectedValue = CommonData.CompanyCode;
cmbDepartment.SelectedValue = "1200000";
cmbRecSour.SelectedValue = "SRC000006";
}
}
private void FillEmployeeData()
{
objServiceDB = new ServiceDB();
ds = objServiceDB.GetECodesforService(BranchCode, DeptCode);
UtilityLibrary.PopulateControl(cmbEmployee, ds.Tables[0].DefaultView, 1, 0, "-- Please Select --", 0);
objServiceDB = null;
}
private void FillFCOProducts()
{
objSQLdb = new SQLDB();
cbProbuct.DataSource = null;
//DataTable dt = new DataTable();
try
{
DataTable dtProducts = objSQLdb.ExecuteDataSet("SELECT DISTINCT PM_PRODUCT_NAME,PM_PRODUCT_ID FROM PRODUCT_MAS where PM_PRODUCT_TYPE = 'SNGPK' "
+ " and PM_BRAND_ID in('VIJETHA','SUPREME','WARRIOR') ORDER BY PM_PRODUCT_NAME").Tables[0];
UtilityLibrary.AutoCompleteComboBox(cbProbuct, dtProducts, "", "PM_PRODUCT_NAME");
if (dtProducts.Rows.Count > 0)
{
DataRow row = dtProducts.NewRow();
row[0] = "ALL";
row[1] = "ALL";
dtProducts.Rows.InsertAt(row, 0);
cbProbuct.DataSource = dtProducts;
cbProbuct.DisplayMember = "PM_PRODUCT_NAME";
cbProbuct.ValueMember = "PM_PRODUCT_ID";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
objSQLdb = null;
}
}
private void BankMaster_Load(object sender, EventArgs e)
{
try
{
//txtBankName.AutoCompleteSource = AutoCompleteSource.CustomSource;
//txtBankName.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
//AutoCompleteStringCollection daColl = new AutoCompleteStringCollection();
objDB = new SQLDB();
DataTable dtBankMas = objDB.ExecuteDataSet("SELECT DISTINCT BIM_BANK_NAME FROM BANK_IFSC_MICR_MAS ORDER BY BIM_BANK_NAME").Tables[0];
DataTable dtStateMas = objDB.ExecuteDataSet("SELECT DISTINCT BIM_STATE FROM BANK_IFSC_MICR_MAS ORDER BY BIM_STATE").Tables[0];
DataTable dtIFSC = objDB.ExecuteDataSet("SELECT DISTINCT BIM_BANK_IFSC_CODE FROM BANK_IFSC_MICR_MAS").Tables[0];
//string[] postSource = dt
// .AsEnumerable()
// .Select<System.Data.DataRow, String>(x => x.Field<String>("BIM_BANK_NAME"))
// .ToArray();
//var source = new AutoCompleteStringCollection();
//source.AddRange(postSource);
//txtBankName.AutoCompleteCustomSource = source;
//txtBankName.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
//txtBankName.AutoCompleteSource = AutoCompleteSource.CustomSource;
UtilityLibrary.AutoCompleteTextBox(txtBankName, dtBankMas, "", "BIM_BANK_NAME");
UtilityLibrary.AutoCompleteTextBox(txtState, dtStateMas, "", "BIM_STATE");
UtilityLibrary.AutoCompleteTextBox(txtIFSC, dtIFSC, "", "BIM_BANK_IFSC_CODE");
}
catch { }
finally { objDB = null; }
dtpTo.Value = DateTime.Now;
}
private void btnSave_Click(object sender, EventArgs e)
{
UtilityLibrary oUtility = new UtilityLibrary();
if (!SSCRM.App_Code.UtilityLibrary.CustomValidate(grouper1, toolTip1))
{
return;
}
try
{
objSQLDB = new SQLDB();
string sReason = "UPDATE HR_APPL_MASTER_HEAD SET HAMH_APPL_PENDING_REASON='" + txtReason.Text + "' WHERE HAMH_COMPANY_CODE='" + CompanyCode + "' AND HAMH_BRANCH_CODE='" + BranchCode + "' and HAMH_APPL_NUMBER=" + iAppliNo;
int iRetVal = objSQLDB.ExecuteSaveData(sReason);
if (iRetVal > 0)
{
MessageBox.Show("Reason updated successfully", "SSCRM Application", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Reason Not updated successfully", "SSCRM Application", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
objSQLDB = null;
((frmApprovedStatus)objApprovedStatus).GetPendingData();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public void GetPopupdropDown()
{
objDB = new SQLDB();
objMstr = new Master();
objSecurity = new Security();
try
{
DataTable dtCpy = objDB.ExecuteDataSet("SELECT CM_Company_Code, CM_Company_Name FROM Company_Mas" +
" ORDER BY CM_Company_Name", CommandType.Text).Tables[0];
//objSecurity.GetCompanyDataSet().Tables[0];
UtilityLibrary.PopulateControl(cmbCompany, dtCpy.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
DataView dvDept = objDB.ExecuteDataSet("SELECT dept_code,dept_name FROM Dept_Mas order by dept_name asc", CommandType.Text).Tables[0].DefaultView;
UtilityLibrary.PopulateControl(cmbDepartMent, dvDept, 1, 0, "--PLEASE SELECT--", 0);
DataView dtRBranch = objDB.ExecuteDataSet("SELECT BRANCH_CODE,BRANCH_NAME FROM BRANCH_MAS ORDER BY BRANCH_NAME ASC", CommandType.Text).Tables[0].DefaultView;
UtilityLibrary.PopulateControl(cmbRepToBranch, dtRBranch, 1, 0, "--PLEASE SELECT--", 0);
DataTable dtSalTypes = objMstr.GetHRSalStructureTypes().Tables[0];
UtilityLibrary.PopulateControl(cmbSalStrType, dtSalTypes.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
DataTable dtSigns = dtAuthSigns();
UtilityLibrary.PopulateControl(cmbAuthortySign, dtSigns.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objDB = null;
objMstr = null;
objSecurity = null;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
UtilityLibrary oUtility = new UtilityLibrary();
if (!SSCRM.App_Code.UtilityLibrary.CustomValidate(grouper1, toolTip1))
{
return;
}
int year = Convert.ToInt32(Convert.ToDateTime(CommonData.CurrentDate).Year) - Convert.ToInt32(Convert.ToDateTime(dtpDOB.Value).Year);
if (year < 18)
{
MessageBox.Show("Dateof birth bellow 18 years not accepted.", "SSCRM Application", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (gvCheckRecords.Rows.Count == 0)
{
DialogResult dlgResult = MessageBox.Show("Do you want enter application?", "Confirm?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dlgResult == DialogResult.Yes)
{
frmApplication frmchld = new frmApplication(txtName.Text, txtFName.Text, dtpDOB.Value, txtSSCNo.Text.Replace(" ", ""), sType);//, txtRecruited.Text, txtTrained.Text, dtFrmDt.Value, dtToDt.Value);
frmchld.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
frmchld.MdiParent = MdiParent;
frmchld.Show();
this.Close();
}
}
else
{
MessageBox.Show("Data Matched with others", "SSCRM Application", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void AddJVAccountDetails_Load(object sender, EventArgs e)
{
txtSiNo.Text = (((JournalVoucher)objJournalVoucher).gvBillDetails.Rows.Count + 1).ToString();
DataTable dtAccMas;
objDB = new SQLDB();
//lblMajorCost.Visible = true;
//cmbMajorCost.Visible = true;
dtAccMas = objDB.ExecuteDataSet(" SELECT AM_ACCOUNT_ID,AM_ACCOUNT_NAME AccName FROM FA_ACCOUNT_MASTER WHERE AM_COMPANY_CODE='" + CommonData.CompanyCode + "' AND AM_COSTCENTRE_FLAG='Y' and AM_ACCOUNT_GROUP_ID IS NULL ").Tables[0];
UtilityLibrary.AutoCompleteComboBox(cmbAccounts, dtAccMas, "AM_ACCOUNT_ID", "AccName");
if (dtAccMas.Rows.Count > 0)
{
DataRow dr = dtAccMas.NewRow();
cmbAccounts.DataSource = dtAccMas;
cmbAccounts.DisplayMember = "AccName";
cmbAccounts.ValueMember = "AM_ACCOUNT_ID";
}
if (drs != null)
{
txtSiNo.Text = drs[0]["SL_NO"].ToString();
cmbAccounts.SelectedValue = drs[0]["ACC_ID"].ToString();
//cmbMajorCost.SelectedValue = drs[0]["MAJCOST_ID"].ToString();
//cbPaymentMode.SelectedItem = drs[0]["PAYMENT_MODE"].ToString();
//txtChqDDNo.Text = drs[0]["CHQ_DD_NO"].ToString();
txtReceivedAmt.Text = drs[0]["AMOUNT"].ToString();
//txtRemarks.Text = drs[0]["REMARKS"].ToString();
}
}
public void GetPopupdropDown()
{
objSecurity = new Security();
DataTable dtCpy = objSecurity.GetCompanyDataSet().Tables[0];
UtilityLibrary.PopulateControl(cmbCompany, dtCpy.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
objSecurity = null;
}
public void GetBindData()
{
objSQLDB = new SQLDB();
DataSet ds = objSQLDB.ExecuteDataSet("SELECT *FROM BRANCH_MAS WHERE BRANCH_TYPE='SP' AND ACTIVE='T'");
UtilityLibrary.PopulateControl(cmbBranch, ds.Tables[0].DefaultView, 1, 0, "--PLEASE SELECT--", 0);
objSQLDB = null;
}
public void GetPopupContrpls()
{
objHRInfo = new HRInfo();
DataTable dtBranch = objHRInfo.GetAllBranchList(CommonData.CompanyCode, "BR", "").Tables[0];
UtilityLibrary.PopulateControl(cmbBranch, dtBranch.DefaultView, 1, 0, "--PLEASE SELECT--", 0);
objHRInfo = null;
}
private void m_GuiWizardForm_Cancel(object sender, UtilityLibrary.Wizards.WizardForm.EventWizardCancelArgs e)
{
e.Title = "Cancel";
e.Message = "Are you sure you want to cancel project creation?";
}
private void m_GuiWizardForm_Next(object sender, UtilityLibrary.Wizards.WizardForm.EventNextArgs e)
{
if (e.CurrentPage.Equals (m_GuiWelcomePage) || e.CurrentPage.Equals (m_GuiInfoPage)) {
m_GuiWizardForm.WizardButtons ^= UtilityLibrary.Wizards.WizardForm.TWizardsButtons.Next;
}
else if (e.CurrentPage.Equals (m_GuiDbLoginPage)) {
m_Generator = new SchemaGenerator (m_GuiSqlLogin.ConnectionString);
m_Generator.ExtractSchema ();
m_GuiTableList.Items.Clear ();
foreach (Table table in m_Generator.TableList) {
m_GuiTableList.Items.Add (table, (!table.Name.StartsWith ("sys")));
}
m_GuiTableList.DisplayMember = "Name";
}
}
public static ProcessedHistoricalData GetChartData(int[] roomID, DateTime startDate, DateTime endDate, int scale)
{
if (roomID.Length == 0)
{
throw new Exception("Minst ett rum måste anges!");
}
var Service = new Service();
var UtilityLibrary = new UtilityLibrary();
// Prepare an object to contain the data from database
var rawHistory = new RawHistory[roomID.Length];
for (int i = 0; i < rawHistory.Length; i++)
{
rawHistory[i] = new RawHistory();
}
for (int i = 0; i < rawHistory.Length; i++)
{
rawHistory[i].TemperatureAndTimestamp = new List<RawData>();
}
// Get all data from database and store it in the previously created object
for (int i = 0; i < roomID.Length; i++)
{
try
{
// Add room description
var tempRoomDescription = new Domain.Model.BLL.Room();
tempRoomDescription = Service.GetRoomByID(roomID[i]);
rawHistory[i].RoomDescription = tempRoomDescription.RoomDescription;
// Add timestamp and temperatures
IEnumerable<Domain.Model.BLL.Temperature> tempHistory = Service.GetTemperaturesByRoomIDAndDate(roomID[i], startDate, endDate);
var tempHistoryArray = tempHistory.ToArray();
var lengthOfArray = tempHistoryArray.Length / scale;
var rawData = new RawData[tempHistoryArray.Length];
for (int j = 0; j < rawData.Length; j++)
{
rawData[j] = new RawData();
}
for (int j = 0; j < tempHistoryArray.Length; j++)
{
rawData[j].Temperature = tempHistoryArray[j].Temp;
rawData[j].TimeStamp = DateTime.Parse(tempHistoryArray[j].Timestamp.ToString());
}
for (int j = 0; j < tempHistoryArray.Length; j++)
{
rawHistory[i].TemperatureAndTimestamp.Add(rawData[j]);
}
}
catch (Exception ex)
{
throw new Exception("Ett fel uppstod vid hämtning av historiken; " + ex.Message);
}
}
// Refactor the object to remove unnecessary data and duplicates and make it JSON-friendly
var historicalReadings = UtilityLibrary.BreakOutTimestampFromRawHistory(rawHistory, scale);
return historicalReadings;
}
private void m_GuiWizardForm_Finish(object sender, UtilityLibrary.Wizards.WizardForm.EventNextArgs e)
{
m_NewProject.OutputPath = m_GuiOutputPath.Text;
m_NewProject.Namespace = m_GuiClassNamespace.Text;
m_NewProject.ConnectionString = m_GuiSqlLogin.ConnectionString;
m_NewProject.TableList.AddRange (m_Generator.TableList);
// this does not work because the primary and foreign keys have references back to the containing table
// this causes a circular reference which the xml serializer does not like.
//m_NewProject.Save (@"c:\test.dtgproj");
this.DialogResult = DialogResult.OK;
this.Close ();
}
