private void Cost_Cat_Mast_Load(object sender, EventArgs e)
{
DataAccess_Net.clsDataAccess._databaseName = this.pComDbnm;
DataAccess_Net.clsDataAccess._serverName = this.pServerName;
DataAccess_Net.clsDataAccess._userID = this.pUserId;
DataAccess_Net.clsDataAccess._password = this.pPassword;
oDataAccess = new DataAccess_Net.clsDataAccess();
CultureInfo ci = new CultureInfo("en-US");
ci.DateTimeFormat.ShortDatePattern = "dd/MM/yyyy";
Thread.CurrentThread.CurrentCulture = ci;
validations = new Dictionary <string, string>();
this.pAppPath = Application.StartupPath;
this.btnCancel.Enabled = false;
this.btnLocate.Enabled = true;
this.btnPreview.Enabled = false;
this.btnPrint.Enabled = false;
this.btnHelp.Enabled = false;
this.btnCalculator.Enabled = false;
this.btnExit.Visible = false;
this.btnEmail.Enabled = false;
this.panel1.Enabled = false;
this.panel2.Visible = false;
this.Height = 188;
this._strSQL = "SELECT cost_cat_id,cost_cat_name,descript,activat FROM ";
dsMain = GetDataFromSelectedTable(this._strSQL, this._TableName, oDataAccess);
ControlBind(this._TableName);
this.mInsertProcessIdRecord();
}
public DataSet GetDataFromSelectedTable(string strSQL, string tableName, DataAccess_Net.clsDataAccess oDataAccess)
{
DataSet dsData = new DataSet();
try
{
strSQL = strSQL + tableName;
dsData = oDataAccess.GetDataSet(strSQL, null, 20);
dsData.Tables[0].TableName = "FormInfo";
}
catch (Exception ex)
{
// throw ex;
errorhandle(ex.Message);
}
finally
{
//objParam = null;
//colParams = null;
//oDataAccess = null;
}
return(dsData);
}
public int SaveFormData(string tableName, DataAccess_Net.clsDataAccess oDataAccess)
{
int id = 0;
DataSet dsData = new DataSet();
StringBuilder strFieldNames = new StringBuilder();
StringBuilder strFieldValues = new StringBuilder();
string strSQL = "";
try
{
//strSQL = "SELECT * FROM " + tableName +" Where cost_cat_name = "+"'"+this.cmbGroup.Text +"'";
//dsData = oDataAccess.GetDataSet(strSQL, null, 20);
//dsData.Tables[0].TableName = "TmpData";
// int j = this.BindingContext[dsMain.Tables[0]].Position;
CurrencyManager cm = (CurrencyManager)this.BindingContext[dsMain.Tables[0]];
DataRow findRow = ((DataRowView)cm.Current).Row;
int j = dsMain.Tables[0].Rows.IndexOf(findRow);
//if (dsData.Tables[0].Rows.Count == 0)
//{
// dsMain.Tables[0].Rows[0]["gr_cost_id"] = 9999;
//}
//else
//{
// dsMain.Tables[0].Rows[j]["gr_cost_id"] = dsData.Tables[0].Rows[0]["cost_cat_id"];
//}
//dsMain.Tables[0].AcceptChanges();
if (this.pAddMode)
{
oDataAccess.BeginTransaction();
strSQL = InsertStatment(tableName, null);
oDataAccess.ExecuteSQLStatement(strSQL, null, 20, true);
// Added By Pankaj B. on 16-02-2015 for Bug-25197 Start
strSQL = "select cmastcode,dbexport from Tbl_DataExport_Mast where ctype='M' and cmastcode='cost_Cat_mast'";
dsExport = oDataAccess.GetDataSet(strSQL, null, 25);
if (dsExport.Tables[0].Rows.Count != 0)
{
ExportTbl = dsExport.Tables[0].Rows[0]["dbexport"].ToString().Trim() + ".dbo." + tableName;
strSQL = InsertStatment(ExportTbl, null);
oDataAccess.ExecuteSQLStatement(strSQL, null, 20, true);
}
// Added By Pankaj B. on 16-02-2015 for Bug-25197 End
oDataAccess.CommitTransaction();
}
if (this.pEditMode)
{
oDataAccess.BeginTransaction();
strSQL = UpdateStatment(tableName, "cost_cat_id") + " where cost_cat_id=" + dsMain.Tables[0].Rows[j]["cost_cat_id"].ToString();
oDataAccess.ExecuteSQLStatement(strSQL, null, 20, true);
// Added By Pankaj B. on 16-02-2015 for Bug-25197 Start
strSQL = "select cmastcode,dbexport from Tbl_DataExport_Mast where ctype='M' and cmastcode='cost_Cat_mast'";
dsExport = oDataAccess.GetDataSet(strSQL, null, 25);
if (dsExport.Tables[0].Rows.Count != 0)
{
ExportTbl = dsExport.Tables[0].Rows[0]["dbexport"].ToString().Trim() + ".dbo." + tableName;
strSQL = UpdateStatment(ExportTbl, "cost_cat_id") + " where cost_cat_id=(select cost_cat_id from " + ExportTbl + " where cost_cat_name= '" + dsMain.Tables[0].Rows[j]["cost_cat_name"].ToString() + "')";
oDataAccess.ExecuteSQLStatement(strSQL, null, 20, true);
}
// Added By Pankaj B. on 16-02-2015 for Bug-25197 End
oDataAccess.CommitTransaction();
}
}
catch (Exception ex)
{
// throw ex;
errorhandle(ex.Message);
}
finally
{
//objParam = null;
//colParams = null;
//oDataAccess = null;
}
return(id);
}
