public static bool IsDataExists(string SQL, string Message)
{
bool retValue = false;
if (SQL == "" || SQL == null)
{
return(retValue);
}
if (Message == "" || Message == null)
{
Message = "Data can't be deleted";
}
DataSet oDS = BOGeneral.GetDataset(SQL);
foreach (DataTable oDT in oDS.Tables)
{
if (oDT.Rows.Count > 0)
{
retValue = true;
//DSExceptions.Messages.Add("", Message, ExceptionType.Information);
break;
}
}
oDS.Dispose();
return(retValue);
}
public static void initializeData()
{
DataTable dtGetData = BOGeneral.GetDataset("SELECT Key1,Key2,ParamValue FROM allparam WHERE Key2='Email'").Tables[0];
if (dtGetData.Rows.Count > 0)
{
foreach (DataRow row in dtGetData.Rows)
{
switch (Convert.ToString(row["Key1"]).ToUpper())
{
case "ETO":
TO = Convert.ToString(row["ParamValue"]);
break;
case "ECC":
CC = Convert.ToString(row["ParamValue"]);
break;
case "EBCC":
BCC = Convert.ToString(row["ParamValue"]);
break;
case "EUSERNAME":
UserName = Convert.ToString(row["ParamValue"]);
break;
case "EPASSWORD":
DomainPass = Convert.ToString(row["ParamValue"]);
break;
case "EFROM":
EMailFrom = Convert.ToString(row["ParamValue"]);
break;
case "ESSLENABLE":
SSLEnable = Convert.ToBoolean(Convert.ToString(row["ParamValue"]));
break;
case "EMAILSERVR":
MailServer = Convert.ToString(row["ParamValue"]);
break;
default:
break;
}
}
}
}
private void frmPronDiaCalc_Load(object sender, EventArgs e)
{
BOGeneral dtProd = new BOGeneral();
DataTable dt = dtProd.SelectPronDiarioCalculado();
pivotGridControl1.BeginUpdate();
pivotGridControl1.DataSource = dt;
pivotGridControl1.EndUpdate();
pivotGridControl1.OptionsCustomization.AllowFilterBySummary = false;
pivotGridControl1.OptionsView.ShowColumnGrandTotals = false;
pivotGridControl1.OptionsView.ShowRowGrandTotals = false;
gcIdarticulo.Width = 90;
gcDesc.Width = 180;
gcCat.Width = 100;
gcMa.Width = 100;
gcSu.Width = 100;
gcPre.Width = 100;
gcUni.Width = 70;
}
public bool ExistsQuery(string CheckID, string CheckName, string tableName, string attributeId1, string attributeName2, string attributeName3, string CheckParentID)
{
string sQuery = string.Empty;
if (!string.IsNullOrEmpty(CheckID))
{
sQuery = BOGeneral.MakeQueryForDataExistChecking(tableName, attributeName2 + "=" + BOGeneral.MakeInsertable(CheckName, true) + "", attributeId1 + "<>" + CheckID + "", attributeName3 + "=" + CheckParentID);
}
else
{
sQuery = BOGeneral.MakeQueryForDataExistChecking(tableName, attributeName2 + "=" + BOGeneral.MakeInsertable(CheckName, true) + "", attributeName3 + "=" + CheckParentID);
}
if (clsGeneral.IsDataExists(sQuery, "Exists"))
{
return(false);
}
else
{
return(true);
}
}
private void frmPronMensual_Load(object sender, EventArgs e)
{
BOGeneral dtProd = new BOGeneral();
DataTable dt = dtProd.SelectPronMensual();
pivotGridControl1.BeginUpdate();
pivotGridControl1.DataSource = dt;
pivotGridControl1.EndUpdate();
pivotGridControl1.OptionsCustomization.AllowFilterBySummary = false;
pivotGridControl1.OptionsView.ShowColumnGrandTotals = false;
pivotGridControl1.OptionsView.ShowRowGrandTotals = false;
//para diferenciar los editables
gcVenta.Appearance.Cell.BackColor = Color.FromArgb(161, 226, 161);
gcId_articulo.Width = 90;
gcDesc.Width = 180;
gcCat.Width = 100;
gcMa.Width = 100;
gcSub.Width = 100;
gcPre.Width = 100;
gcUni.Width = 70;
}
private static DropDownList FillDropdownList(string flb_tableName, string flb_DataTextField, string flb_DataValueField, string flb_whereCauseWithAndwithoutflag, DropDownList flb_dropdownList, string SelectFieldText, bool SelectFieldTextVisible, string flb_orderby, string ExtraJoin)
{
string sQuery = string.Empty;
if (flb_dropdownList != null)
{
flb_dropdownList.Items.Clear();
if (!string.IsNullOrEmpty(flb_tableName) && !string.IsNullOrEmpty(flb_DataTextField) && !string.IsNullOrEmpty(flb_DataValueField))
{
if (!string.IsNullOrEmpty(flb_whereCauseWithAndwithoutflag))
{
if (!flb_whereCauseWithAndwithoutflag.Trim().StartsWith("and"))
{
flb_whereCauseWithAndwithoutflag = " where " + flb_whereCauseWithAndwithoutflag;
}
}
sQuery = "Select " + flb_DataValueField + "," + flb_DataTextField + " from " + flb_tableName + " " + ExtraJoin + " " + flb_whereCauseWithAndwithoutflag + " order By " + flb_orderby;
DataSet dsDropdownList = BOGeneral.GetDataset(sQuery);
if (dsDropdownList != null)
{
if (dsDropdownList.Tables.Count > 0)
{
DataTable dtDropdownList = dsDropdownList.Tables[0];
if (dtDropdownList.Rows.Count > 0)
{
flb_dropdownList.DataSource = dtDropdownList;
flb_dropdownList.DataTextField = flb_DataTextField;
flb_dropdownList.DataValueField = flb_DataValueField;
flb_dropdownList.DataBind();
}
}
}
}
if (SelectFieldTextVisible == true)
{
flb_dropdownList.Items.Insert(0, new ListItem(" " + SelectFieldText + " ", "0"));
}
}
return(flb_dropdownList);
}
public static DataSet GetBindDropDownDataSet(string DDLTypeName, string SelectString, string WhereClause)
{
DataSet oDS;
string OrderBy = "";
if (SelectString == null || SelectString == "")
{
SelectString = "-----Select-----";
}
if (WhereClause.IndexOf("-999999") > 0)
{
oDS = new DataSet();
oDS.Tables.Add(new DataTable());
if (SelectString != null && SelectString != "")
{
oDS.Tables[0].Columns.Add("TextField", Type.GetType("System.String"));
oDS.Tables[0].Columns.Add("ValueField", Type.GetType("System.String"));
DataRow dr = oDS.Tables[0].NewRow();
dr["TextField"] = SelectString;
dr["ValueField"] = "-999999";
oDS.Tables[0].Rows.InsertAt(dr, 0);
}
return(oDS);
}
string SQL = "";
DDLTypeName = DDLTypeName.ToUpper();
if (DDLTypeName == enumDropDownType.UserList.ToString().ToUpper())
{
//OrderBy = "order by TextField";
if (WhereClause == "")
{
SQL = "Select UserName as TextField, UserID as ValueField from UserMast ";
}
else
{
SQL = "Select UserName as TextField, UserID as ValueField from UserMast Where " + WhereClause + " ";
}
SQL += " order by TextField";
}
else if (DDLTypeName == enumDropDownType.AllCompany.ToString().ToUpper())
{
SQL = "Select CmpName as TextField, CmpID as ValueField from cmpmast order by CmpName";
}
else if (DDLTypeName == enumDropDownType.CompanyList.ToString().ToUpper())
{
OrderBy = "order by cm.CmpName";
if (WhereClause == "")
{
SQL = "Select Distinct CmpName as TextField, cm.CmpID as ValueField from cmpmast cm inner join userrights ur ";
SQL += "on cm.CmpID = ur.cmpid ";
}
else
{
SQL = "Select Distinct CmpName as TextField, cm.CmpID as ValueField from cmpmast cm inner join userrights ur ";
SQL += "on cm.CmpID = ur.cmpid Where " + WhereClause + " ";
}
SQL += " order by TextField";
}
else if (DDLTypeName == enumDropDownType.RoleList.ToString().ToUpper())
{
OrderBy = "order by RoleName";
if (WhereClause == "")
{
SQL = "Select RoleName as TextField, RoleID as ValueField from RoleMst ";
}
else
{
SQL = "Select RoleName as TextField, RoleID as ValueField from RoleMst Where " + WhereClause + " ";
}
SQL += " order by TextField";
}
else if (DDLTypeName == enumDropDownType.CategoryList.ToString().ToUpper())
{
OrderBy = "order by CategoryName";
if (WhereClause == "")
{
SQL = "Select CategoryName as TextField, CategoryID as ValueField from tblCategory Where Flag=0 or Flag=null";
}
else
{
SQL = "Select CategoryName as TextField, CategoryID as ValueField from tblCategory Where (Flag=0 or Flag=null) and " + WhereClause + " ";
}
SQL += " order by TextField";
}
else if (DDLTypeName == enumDropDownType.KeywordList.ToString().ToUpper())
{
OrderBy = "order by KeywordName";
if (WhereClause == "")
{
SQL = "Select KeywordName as TextField, KeywordID as ValueField from tblKeyword Where Flag=0 or Flag=null ";
}
else
{
SQL = "Select KeywordName as TextField, KeywordID as ValueField from tblKeyword Where (Flag=0 or Flag=null) and " + WhereClause + " ";
}
SQL += " order by TextField";
}
else if (DDLTypeName == enumDropDownType.CityList.ToString().ToUpper())
{
OrderBy = "order by CityName";
if (WhereClause == "")
{
SQL = "Select CityName as TextField, CityID as ValueField from tblCity Where Flag=0 or Flag=null ";
}
else
{
SQL = "Select CityName as TextField, CityID as ValueField from tblCity Where (Flag=0 or Flag=null) and " + WhereClause + " ";
}
SQL += " order by TextField";
}
else if (DDLTypeName == enumDropDownType.AreaList.ToString().ToUpper())
{
OrderBy = "order by AreaName";
if (WhereClause == "")
{
SQL = "Select AreaName as TextField, AreaID as ValueField from tblArea Where Flag=0 or Flag=null ";
}
else
{
SQL = "Select AreaName as TextField, AreaID as ValueField from tblArea Where (Flag=0 or Flag=null) and " + WhereClause + " ";
}
SQL += " order by TextField";
}
else if (DDLTypeName == enumDropDownType.PackList.ToString().ToUpper())
{
OrderBy = "order by PackName";
if (WhereClause == "")
{
SQL = "Select PackName as TextField, PackID as ValueField from tblPackage Where Flag=0 or Flag=null ";
}
else
{
SQL = "Select PackName as TextField, PackID as ValueField from tblPackage Where (Flag=0 or Flag=null) and " + WhereClause + " ";
}
SQL += " order by TextField";
}
#region DataSet Function
oDS = BOGeneral.GetDataset(SQL);
if (oDS != null)
{
if (oDS.Tables.Count > 0)
{
if (SelectString != null && SelectString != "")
{
DataRow dr = oDS.Tables[0].NewRow();
dr["TextField"] = SelectString;
dr["ValueField"] = "-999999";
oDS.Tables[0].Rows.InsertAt(dr, 0);
}
}
}
return(oDS);
#endregion
}
