//ADD DATA IN DepartmentMASTER TABLE
public static int SpWMasterAddData(string mmasterid, string title, string description, string week, string budgetedcost)
{
// get a configured DbCommand object
DbCommand comm = DataAccess.CreateCommand();
// set the stored procedure name
comm.CommandText = "SpWMasterAddData";
// create a new parameter
DbParameter param = comm.CreateParameter();
param.ParameterName = "@mmasterid";
param.Value = mmasterid;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@title";
param.Value = title;
param.DbType = DbType.String;
param.Size = 500;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@description";
param.Value = description;
param.DbType = DbType.String;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@week";
param.Value = week;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@budgetedcost";
param.Value = budgetedcost;
param.DbType = DbType.Decimal;
comm.Parameters.Add(param);
comm.Parameters.Add(new SqlParameter("@MasterId", SqlDbType.Int));
comm.Parameters["@MasterId"].Direction = ParameterDirection.Output;
comm.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
comm.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
Int32 result = DatabaseCls1.ExecuteNonQueryep(comm);
//if (result > 0)
//{
result = Convert.ToInt32(comm.Parameters["@MasterId"].Value);
//}
return(result);
}
public static DataTable selectIPrestriction(String Ipaddress, int flag, String username, String password, String CID)
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
cmd.CommandText = "selectIPrestriction";
cmd.Parameters.Add(new SqlParameter("@Ipaddress", SqlDbType.NVarChar));
cmd.Parameters["@Ipaddress"].Value = Ipaddress; // CompanyLoginId;
cmd.Parameters.Add(new SqlParameter("@flag", SqlDbType.Int));
cmd.Parameters["@flag"].Value = @flag; // CompanyLoginId;
cmd.Parameters.Add(new SqlParameter("@username", SqlDbType.NVarChar));
cmd.Parameters["@username"].Value = @username; // CompanyLoginId;
cmd.Parameters.Add(new SqlParameter("@password", SqlDbType.NVarChar));
cmd.Parameters["@password"].Value = password; // CompanyLoginId;
cmd.Parameters.Add(new SqlParameter("@CID", SqlDbType.NVarChar));
cmd.Parameters["@CID"].Value = CID;
dt = DatabaseCls1.FilleppAdapter(cmd); //.FillAdapter(cmd);
return(dt);
}
public Int32 InsertDownloadFolder(String FolderName, bool FolderRule, bool DocumentAutoApprove, String RuleType, String Whid)
{
cmd = new SqlCommand();
cmd.CommandText = "InsertDownloadFolder";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@FolderName", SqlDbType.NVarChar));
cmd.Parameters["@FolderName"].Value = FolderName;
cmd.Parameters.Add(new SqlParameter("@FolderRule", SqlDbType.Bit));
cmd.Parameters["@FolderRule"].Value = FolderRule;
cmd.Parameters.Add(new SqlParameter("@DocumentAutoApprove", SqlDbType.Bit));
cmd.Parameters["@DocumentAutoApprove"].Value = DocumentAutoApprove;
cmd.Parameters.Add(new SqlParameter("@RuleType", SqlDbType.VarChar));
cmd.Parameters["@RuleType"].Value = RuleType;
cmd.Parameters.Add(new SqlParameter("@CID", SqlDbType.NVarChar));
cmd.Parameters["@CID"].Value = HttpContext.Current.Session["Comid"].ToString();
cmd.Parameters.Add(new SqlParameter("@Whid", SqlDbType.NVarChar));
cmd.Parameters["@Whid"].Value = Whid;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(new SqlParameter("@FolderId", SqlDbType.Int));
cmd.Parameters["@FolderId"].Direction = ParameterDirection.Output;
Int32 result = DatabaseCls1.ExecuteNonQueryep(cmd);
result = Convert.ToInt32(cmd.Parameters["@FolderId"].Value.ToString());
return(result);
//Int32 result = DatabaseCls1.ExecuteNonQuery(cmd);
//result = 0;
//result = Convert.ToInt32(cmd.Parameters["@ReturnValue"].Value.ToString());
//return result;
}
public Int32 InsertCompanyAddressDetail(Int32 CompanyId, Int32 CompanyAddressTypeId, String Address, String City, String StateName, String PinCode, String Email, String Fax, String ContactNo, String WebsiteAddress, String CountyName)
{
cmd = new SqlCommand();
cmd.CommandText = "InsertCompanyAddressDetail";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@CompanyId", SqlDbType.Int));
cmd.Parameters["@CompanyId"].Value = CompanyId;
cmd.Parameters.Add(new SqlParameter("@CompanyAddressTypeId", SqlDbType.Int));
cmd.Parameters["@CompanyAddressTypeId"].Value = CompanyAddressTypeId;
cmd.Parameters.Add(new SqlParameter("@Address", SqlDbType.NVarChar));
cmd.Parameters["@Address"].Value = Address;
cmd.Parameters.Add(new SqlParameter("@City", SqlDbType.NVarChar));
cmd.Parameters["@City"].Value = City;
cmd.Parameters.Add(new SqlParameter("@StateName", SqlDbType.NVarChar));
cmd.Parameters["@StateName"].Value = StateName;
cmd.Parameters.Add(new SqlParameter("@PinCode", SqlDbType.NVarChar));
cmd.Parameters["@PinCode"].Value = PinCode;
cmd.Parameters.Add(new SqlParameter("@Email", SqlDbType.NVarChar));
cmd.Parameters["@Email"].Value = Email;
cmd.Parameters.Add(new SqlParameter("@Fax", SqlDbType.NVarChar));
cmd.Parameters["@Fax"].Value = Fax;
cmd.Parameters.Add(new SqlParameter("@ContactNo", SqlDbType.NVarChar));
cmd.Parameters["@ContactNo"].Value = ContactNo;
cmd.Parameters.Add(new SqlParameter("@WebsiteAddress", SqlDbType.NVarChar));
cmd.Parameters["@WebsiteAddress"].Value = WebsiteAddress;
cmd.Parameters.Add(new SqlParameter("@CountryName", SqlDbType.NVarChar));
cmd.Parameters["@CountryName"].Value = CountyName;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
Int32 result = DatabaseCls1.ExecuteNonQuery(cmd);
return(result);
}
public static int Sp_Insert_TranctionMasterSuppliment(int TransactionMasterId, String Memo, Decimal AmountDue, int PartyMasterId, int GrnMasterId)
{
SqlCommand cmd78 = new SqlCommand();
cmd78.CommandText = "Sp_Insert_TranctionMasterSuppliment";
cmd78.CommandType = CommandType.StoredProcedure;
cmd78.Parameters.AddWithValue("@TransactionMasterId", TransactionMasterId);
cmd78.Parameters.AddWithValue("@Memo", Memo);
if (AmountDue > Convert.ToDecimal(0))
{
cmd78.Parameters.AddWithValue("@AmountDue", Convert.ToDecimal(Math.Round(AmountDue, 2)));
}
else
{
cmd78.Parameters.AddWithValue("@AmountDue", DBNull.Value);
}
cmd78.Parameters.AddWithValue("@PartyMasterId", PartyMasterId);
if (GrnMasterId > 0)
{
cmd78.Parameters.AddWithValue("@GrnMasterId", GrnMasterId);
}
else
{
cmd78.Parameters.AddWithValue("@GrnMasterId", DBNull.Value);
}
Int32 result = DatabaseCls1.ExecuteNonQueryep(cmd78);
return(result);
}
public static int Sp_Insert_Tranction_Details1(int AccountDebit, int AccountCredit, Decimal AmountDebit, Decimal AmountCredit, int Tranction_Master_Id, String Memo, DateTime tddate, String Whid)
{
SqlCommand cmd1 = new SqlCommand();
cmd1.CommandText = "Sp_Insert_Tranction_Details1";
cmd1.CommandType = CommandType.StoredProcedure;
if (Convert.ToDouble(Math.Round(Convert.ToDecimal(AmountCredit), 2, MidpointRounding.AwayFromZero).ToString()) > 0)
{
cmd1.Parameters.AddWithValue("@AccountDebit", "0");
cmd1.Parameters.AddWithValue("@AccountCredit", Convert.ToInt32(AccountCredit));
cmd1.Parameters.AddWithValue("@AmountDebit", "0");
cmd1.Parameters.AddWithValue("@AmountCredit", Math.Round(Convert.ToDecimal(AmountCredit), 2));
}
else
{
cmd1.Parameters.AddWithValue("@AccountDebit", Convert.ToInt32(AccountDebit));
cmd1.Parameters.AddWithValue("@AccountCredit", "0");
cmd1.Parameters.AddWithValue("@AmountDebit", (Convert.ToDouble(Math.Round(Convert.ToDecimal(AmountDebit), 2))));
cmd1.Parameters.AddWithValue("@AmountCredit", "0");
}
cmd1.Parameters.AddWithValue("@Tranction_Master_Id", Tranction_Master_Id);
cmd1.Parameters.AddWithValue("@Memo", Memo);
cmd1.Parameters.AddWithValue("@DateTimeOfTransaction", tddate.ToShortDateString());
cmd1.Parameters.AddWithValue("@DiscEarn", DBNull.Value);
cmd1.Parameters.AddWithValue("@DiscPaid", DBNull.Value);
cmd1.Parameters.AddWithValue("@comid", HttpContext.Current.Session["Comid"].ToString());
cmd1.Parameters.AddWithValue("@whid", Whid);
Int32 result = DatabaseCls1.ExecuteNonQueryep(cmd1);
return(result);
}
public Int32 InsertDocumentFolderDownloadDefaultProp(Int32 FolderId, string DocumentTittle, Int32 DocumentTypeId, Int32 PartyId, string DocumentDescription, string AutoInterval, string Docyt)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "InsertDocumentFolderDownloadDefaultProp";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@FolderId", SqlDbType.Int));
cmd.Parameters["@FolderId"].Value = FolderId;
cmd.Parameters.Add(new SqlParameter("@DocumentTittle", SqlDbType.NVarChar));
cmd.Parameters["@DocumentTittle"].Value = DocumentTittle;
cmd.Parameters.Add(new SqlParameter("@DocumentTypeId", SqlDbType.Int));
cmd.Parameters["@DocumentTypeId"].Value = DocumentTypeId;
cmd.Parameters.Add(new SqlParameter("@PartyId", SqlDbType.Int));
cmd.Parameters["@PartyId"].Value = PartyId;
cmd.Parameters.Add(new SqlParameter("@DocumentDescription", SqlDbType.NVarChar));
cmd.Parameters["@DocumentDescription"].Value = DocumentDescription;
cmd.Parameters.Add(new SqlParameter("@DocTypenm", SqlDbType.NVarChar));
cmd.Parameters["@DocTypenm"].Value = Docyt;
cmd.Parameters.Add(new SqlParameter("@AutoInterval", SqlDbType.NVarChar));
cmd.Parameters["@AutoInterval"].Value = AutoInterval;
//cmd.Parameters.Add(new SqlParameter("@DocTittleOrEmailSub", SqlDbType.Bit));
//cmd.Parameters["@DocTittleOrEmailSub"].Value = DocTittleOrEmailSub;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
Int32 result = DatabaseCls1.ExecuteNonQueryep(cmd);
return(result);
}
public static int InsertTransactionMaster(DateTime Date, String EntryNumber, String EntryTypeId, int UserId, Decimal Tranction_Amount, String Whid)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "InsertTransactionMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Date", Convert.ToDateTime(Date).ToShortDateString());
cmd.Parameters.AddWithValue("@EntryNumber", Convert.ToInt64(EntryNumber));
cmd.Parameters.AddWithValue("@EntryTypeId", EntryTypeId);
cmd.Parameters.AddWithValue("@UserId", UserId);
cmd.Parameters.AddWithValue("@comid", HttpContext.Current.Session["Comid"].ToString());
cmd.Parameters.AddWithValue("@whid", Whid);
cmd.Parameters.AddWithValue("@Tranction_Amount", Convert.ToDecimal(Math.Round(Tranction_Amount, 2, MidpointRounding.AwayFromZero).ToString()));
cmd.Parameters.Add(new SqlParameter("@Tranction_Master_Id", SqlDbType.Int));
cmd.Parameters["@Tranction_Master_Id"].Direction = ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
Int32 result = DatabaseCls1.ExecuteNonQueryep(cmd);
if (result > 0)
{
result = Convert.ToInt32(cmd.Parameters["@Tranction_Master_Id"].Value);
}
return(result);
}
public Int32 UpdateCompanyMaster(Int32 IndustryTypeId, Int32 OrganiseTypeId, String LegalName, String AdminName, String CompanyLogo, String StateTaxNumber, String IRSNumber, String CompanyWebsite, String ContactPersonName, String ContactPersonDesignation)
{
cmd = new SqlCommand();
cmd.CommandText = "UpdateCompanyMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IndustryTypeId", SqlDbType.Int));
cmd.Parameters["@IndustryTypeId"].Value = IndustryTypeId;
cmd.Parameters.Add(new SqlParameter("@OrganiseTypeId", SqlDbType.Int));
cmd.Parameters["@OrganiseTypeId"].Value = OrganiseTypeId;
cmd.Parameters.Add(new SqlParameter("@LegalName", SqlDbType.NVarChar));
cmd.Parameters["@LegalName"].Value = LegalName;
cmd.Parameters.Add(new SqlParameter("@AdminName", SqlDbType.NVarChar));
cmd.Parameters["@AdminName"].Value = AdminName;
cmd.Parameters.Add(new SqlParameter("@CompanyLogo", SqlDbType.NVarChar));
cmd.Parameters["@CompanyLogo"].Value = CompanyLogo;
cmd.Parameters.Add(new SqlParameter("@StateTaxNumber", SqlDbType.NVarChar));
cmd.Parameters["@StateTaxNumber"].Value = StateTaxNumber;
cmd.Parameters.Add(new SqlParameter("@IRSNumber", SqlDbType.NVarChar));
cmd.Parameters["@IRSNumber"].Value = IRSNumber;
cmd.Parameters.Add(new SqlParameter("@CompanyWebsite", SqlDbType.NVarChar));
cmd.Parameters["@CompanyWebsite"].Value = CompanyWebsite;
cmd.Parameters.Add(new SqlParameter("@ContactPersonName", SqlDbType.NVarChar));
cmd.Parameters["@ContactPersonName"].Value = ContactPersonName;
cmd.Parameters.Add(new SqlParameter("@ContactPersonDesignation", SqlDbType.NVarChar));
cmd.Parameters["@ContactPersonDesignation"].Value = ContactPersonDesignation;
cmd.Parameters.Add(new SqlParameter("@CompanyName", SqlDbType.NVarChar));
cmd.Parameters["@CompanyName"].Value = HttpContext.Current.Session["CompanyLoginId"].ToString(); // CompanyLoginId;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
Int32 result = DatabaseCls1.ExecuteNonQuery(cmd);
result = 0;
result = Convert.ToInt32(cmd.Parameters["@ReturnValue"].Value.ToString());
return(result);
}
public bool UpdateDocumentFolderDownloadDefaultProp(Int32 DocumentFolderDownloadDefaultPropId, String DocumentTittle, Int32 DocumentTypeId, Int32 PartyId, String DocumentDescription, String AutoInterval)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UpdateDocumentFolderDownloadDefaultProp";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@DocumentFolderDownloadDefaultPropId", SqlDbType.Int));
cmd.Parameters["@DocumentFolderDownloadDefaultPropId"].Value = DocumentFolderDownloadDefaultPropId;
cmd.Parameters.Add(new SqlParameter("@DocumentTittle", SqlDbType.NVarChar));
cmd.Parameters["@DocumentTittle"].Value = DocumentTittle;
cmd.Parameters.Add(new SqlParameter("@DocumentTypeId", SqlDbType.Int));
cmd.Parameters["@DocumentTypeId"].Value = DocumentTypeId;
cmd.Parameters.Add(new SqlParameter("@PartyId", SqlDbType.Int));
cmd.Parameters["@PartyId"].Value = PartyId;
cmd.Parameters.Add(new SqlParameter("@DocumentDescription", SqlDbType.NVarChar));
cmd.Parameters["@DocumentDescription"].Value = DocumentDescription;
cmd.Parameters.Add(new SqlParameter("@AutoInterval", SqlDbType.NVarChar));
cmd.Parameters["@AutoInterval"].Value = AutoInterval;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
int result = DatabaseCls1.ExecuteNonQueryep(cmd);
return(result != -1);
}
public Int32 UpdateCompanyAddressMaster(String Address, String City, Int32 StateId, String PinCode, String ContactNo, String Email, String Fax, String websiteAddress)
{
cmd = new SqlCommand();
cmd.CommandText = "UpdateCompanyAddressMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Address", SqlDbType.NVarChar));
cmd.Parameters["@Address"].Value = Address;
cmd.Parameters.Add(new SqlParameter("@City", SqlDbType.NVarChar));
cmd.Parameters["@City"].Value = City;
cmd.Parameters.Add(new SqlParameter("@StateId", SqlDbType.Int));
cmd.Parameters["@StateId"].Value = StateId;
cmd.Parameters.Add(new SqlParameter("@PinCode", SqlDbType.NVarChar));
cmd.Parameters["@PinCode"].Value = PinCode;
cmd.Parameters.Add(new SqlParameter("@ContactNo", SqlDbType.NVarChar));
cmd.Parameters["@ContactNo"].Value = ContactNo;
cmd.Parameters.Add(new SqlParameter("@Email", SqlDbType.NVarChar));
cmd.Parameters["@Email"].Value = Email;
cmd.Parameters.Add(new SqlParameter("@Fax", SqlDbType.NVarChar));
cmd.Parameters["@Fax"].Value = Fax;
cmd.Parameters.Add(new SqlParameter("@websiteAddress", SqlDbType.NVarChar));
cmd.Parameters["@websiteAddress"].Value = websiteAddress;
cmd.Parameters.Add(new SqlParameter("@CompanyName", SqlDbType.NVarChar));
cmd.Parameters["@CompanyName"].Value = HttpContext.Current.Session["CompanyLoginId"].ToString(); // CompanyLoginId;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
Int32 result = DatabaseCls1.ExecuteNonQuery(cmd);
result = 0;
result = Convert.ToInt32(cmd.Parameters["@ReturnValue"].Value.ToString());
return(result);
}
public Int32 InsertCustomerRetailSaleItemDetail(Int32 CustomerRetailSaleId, Int32 InvId, String SalesPrice, String ChargedPrice, String Amount, String Notes, String Qty, String CustomerPrice, String CustomerQuotedPrice, String Quality)
{
cmd = new SqlCommand();
cmd.CommandText = "InsertCustomerRetailSaleItemDetail";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@CustomerRetailSaleId", SqlDbType.Int));
cmd.Parameters["@CustomerRetailSaleId"].Value = CustomerRetailSaleId;
cmd.Parameters.Add(new SqlParameter("@InvId", SqlDbType.Int));
cmd.Parameters["@InvId"].Value = InvId;
cmd.Parameters.Add(new SqlParameter("@SalesPrice", SqlDbType.NVarChar));
cmd.Parameters["@SalesPrice"].Value = SalesPrice;
cmd.Parameters.Add(new SqlParameter("@ChargedPrice", SqlDbType.NVarChar));
cmd.Parameters["@ChargedPrice"].Value = ChargedPrice;
cmd.Parameters.Add(new SqlParameter("@Amount", SqlDbType.NVarChar));
cmd.Parameters["@Amount"].Value = Amount;
cmd.Parameters.Add(new SqlParameter("@Notes", SqlDbType.NVarChar));
cmd.Parameters["@Notes"].Value = Notes;
cmd.Parameters.Add(new SqlParameter("@Qty", SqlDbType.NVarChar));
cmd.Parameters["@Qty"].Value = Qty;
cmd.Parameters.Add(new SqlParameter("@CustomerPrice", SqlDbType.NVarChar));
cmd.Parameters["@CustomerPrice"].Value = CustomerPrice;
cmd.Parameters.Add(new SqlParameter("@CustomerQuotedPrice", SqlDbType.NVarChar));
cmd.Parameters["@CustomerQuotedPrice"].Value = CustomerQuotedPrice;
cmd.Parameters.Add(new SqlParameter("@Quality", SqlDbType.NVarChar));
cmd.Parameters["@Quality"].Value = Quality;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
Int32 result = DatabaseCls1.ExecuteNonQuery(cmd);
return(result);
}
public Int32 InsertCustomerRetailSaleMaster(Int32 WarehouseId, Int32 ShippersId, String PartyName, String PartyAddress, String BillTo, String ShipTo, Boolean ChkdlvryChallan)
{
cmd = new SqlCommand();
cmd.CommandText = "InsertCustomerRetailSaleMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@WarehouseId", SqlDbType.Int));
cmd.Parameters["@WarehouseId"].Value = WarehouseId;
cmd.Parameters.Add(new SqlParameter("@ShippersId", SqlDbType.Int));
cmd.Parameters["@ShippersId"].Value = ShippersId;
cmd.Parameters.Add(new SqlParameter("@PartyName", SqlDbType.NVarChar));
cmd.Parameters["@PartyName"].Value = PartyName;
cmd.Parameters.Add(new SqlParameter("@PartyAddress", SqlDbType.NVarChar));
cmd.Parameters["@PartyAddress"].Value = PartyAddress;
cmd.Parameters.Add(new SqlParameter("@BillTo", SqlDbType.NVarChar));
cmd.Parameters["@BillTo"].Value = BillTo;
cmd.Parameters.Add(new SqlParameter("@ShipTo", SqlDbType.NVarChar));
cmd.Parameters["@ShipTo"].Value = ShipTo;
cmd.Parameters.Add(new SqlParameter("@ChkdlvryChallan", SqlDbType.Bit));
cmd.Parameters["@ChkdlvryChallan"].Value = ChkdlvryChallan;
cmd.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(new SqlParameter("@CustomerRetailSaleId", SqlDbType.Int));
cmd.Parameters["@CustomerRetailSaleId"].Direction = ParameterDirection.Output;
Int32 result = DatabaseCls1.ExecuteNonQuery(cmd);
result = Convert.ToInt32(cmd.Parameters["@CustomerRetailSaleId"].Value.ToString());
return(result);
}
public static DataTable Selectltgddfilter(String Whid, String Deptid, String BusinessID, String EmployeemasterId, int flag, String dateid)
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
cmd.CommandText = "Selectltgddfilter";
cmd.Parameters.Add(new SqlParameter("@Deptid", SqlDbType.NVarChar));
cmd.Parameters["@Deptid"].Value = Deptid; // Convert.ToInt32(HttpContext.Current.Session["EmployeeId"].ToString()); // EmployeeId;
cmd.Parameters.Add(new SqlParameter("@BusinessID", SqlDbType.NVarChar));
cmd.Parameters["@BusinessID"].Value = BusinessID;
cmd.Parameters.Add(new SqlParameter("@Whid", SqlDbType.NVarChar));
cmd.Parameters["@Whid"].Value = Whid;
cmd.Parameters.Add(new SqlParameter("@EmployeemasterId", SqlDbType.NVarChar));
cmd.Parameters["@EmployeemasterId"].Value = EmployeemasterId;
cmd.Parameters.Add(new SqlParameter("@dateid", SqlDbType.NVarChar));
cmd.Parameters["@dateid"].Value = dateid;
cmd.Parameters.Add(new SqlParameter("@CID", SqlDbType.NVarChar));
cmd.Parameters["@CID"].Value = HttpContext.Current.Session["Comid"].ToString(); // CompanyLoginId;
cmd.Parameters.Add(new SqlParameter("@flag", SqlDbType.NVarChar));
cmd.Parameters["@flag"].Value = flag; // CompanyLoginId;
dt = DatabaseCls1.FilleppAdapter(cmd); //.FillAdapter(cmd);
return(dt);
}
public static int Updateactuccostproject(string MissionId, decimal ActualCost, decimal ShortageExcess, String StatusId, String reminder)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Updateactuccostproject";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@masterid", SqlDbType.NVarChar));
cmd.Parameters["@masterid"].Value = MissionId; // Convert.ToInt32(HttpContext.Current.Session["EmployeeId"].ToString()); // EmployeeId;
cmd.Parameters.Add(new SqlParameter("@ActualCost", SqlDbType.Decimal));
cmd.Parameters["@ActualCost"].Value = ActualCost; // Convert.ToInt32(HttpContext.Current.Session["EmployeeId"].ToString()); // EmployeeId;
cmd.Parameters.Add(new SqlParameter("@StatusId", SqlDbType.NVarChar));
cmd.Parameters["@StatusId"].Value = StatusId;
cmd.Parameters.Add(new SqlParameter("@ShortageExcess", SqlDbType.Decimal));
cmd.Parameters["@ShortageExcess"].Value = ShortageExcess; // Convert.ToInt32(HttpContext.Current.Session["EmployeeId"].ToString()); // EmployeeId;
cmd.Parameters.Add(new SqlParameter("@Reminder", SqlDbType.NVarChar));
cmd.Parameters["@Reminder"].Value = reminder;
int I = DatabaseCls1.ExecuteNonQueryep(cmd); //.FillAdapter(cmd);
return(I);
}
//ADD DATA IN DepartmentMASTER TABLE
public static int SpObjectiveDetailAddData(string masterid, string detail, string userid, String sDate)
{
// get a configured DbCommand object
DbCommand comm = DataAccess.CreateCommand();
// set the stored procedure name
comm.CommandText = "SpObjectiveDetailAddData";
// create a new parameter
DbParameter param = comm.CreateParameter();
param.ParameterName = "@masterid";
param.Value = masterid;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@detail";
param.Value = detail;
param.DbType = DbType.String;
param.Size = 80000;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@userid";
param.Value = userid;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@Date";
param.Value = sDate;
param.DbType = DbType.String;
comm.Parameters.Add(param);
comm.Parameters.Add(new SqlParameter("@DetailId", SqlDbType.Int));
comm.Parameters["@DetailId"].Direction = ParameterDirection.Output;
comm.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
comm.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
Int32 result = DatabaseCls1.ExecuteNonQueryep(comm);
//if (result > 0)
//{
result = Convert.ToInt32(comm.Parameters["@DetailId"].Value);
//}
return(result);
//int result = -1;
//result = DataAccess.ExecuteNonQuery(comm);
//return (result != -1);
}
public DataTable SelectSalesOrderMasterTopId()
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectSalesOrderMasterTopId";
dt = DatabaseCls1.ExecuteScalar(cmd); // DatabaseCls1.ExecuteNonQuerywithReturn(cmd);
return(dt);
}
public DataTable SelectShippperMaster()
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectShipperMaster";
dt = DatabaseCls1.FillAdapter(cmd);
return(dt);
}
public DataTable selectCompanyAddressTypeMaster()
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "selectCompanyAddressTypeMaster";
dt = DatabaseCls1.FillAdapter(cmd);
return(dt);
}
public DataTable selectCompanyEmailMaster()
{
cmd = new SqlCommand();
DataTable dtIp = new DataTable();
cmd.CommandText = "selectCompanyEmailMaster";
dtIp = DatabaseCls1.FillAdapter(cmd);
return(dtIp);
}
//ADD DATA IN DepartmentMASTER TABLE
public static Int32 SpTacticEvaluationAddData(string MasterId, string Date, string Percentage, string EvaluationNote)
{
// get a configured DbCommand object
DbCommand comm = DataAccess.CreateCommand();
// set the stored procedure name
comm.CommandText = "SpTacticEvaluationAddData";
// create a new parameter
DbParameter param = comm.CreateParameter();
param = comm.CreateParameter();
param.ParameterName = "@MasterId";
param.Value = MasterId;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@Date";
param.Value = Date;
param.DbType = DbType.DateTime;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@Percentage";
param.Value = Percentage;
param.DbType = DbType.String;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@EvaluationNote";
param.Value = EvaluationNote;
param.DbType = DbType.String;
param.Size = 80000;
comm.Parameters.Add(param);
comm.Parameters.Add(new SqlParameter("@EvaluationId", SqlDbType.Int));
comm.Parameters["@EvaluationId"].Direction = ParameterDirection.Output;
comm.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
comm.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
Int32 result = DatabaseCls1.ExecuteNonQueryep(comm);
//if (result > 0)
//{
result = Convert.ToInt32(comm.Parameters["@EvaluationId"].Value);
//}
return(result);
}
public DataTable selectIndustryTypeMaster()
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "selectIndustryTypeMaster";
//cmd.Parameters.Add(new SqlParameter("@CID", SqlDbType.NVarChar));
//cmd.Parameters["@CID"].Value = HttpContext.Current.Session["CompanyLoginId"].ToString(); // CompanyLoginId;
dt = DatabaseCls1.FillAdapter(cmd);
return(dt);
}
public DataTable SelectWarehouseMasterWithID(Int32 WarehouseId)
{
cmd = new SqlCommand();
dt = new DataTable();
cmd.CommandText = "SelectWarehouseMasterWithID";
cmd.Parameters.Add(new SqlParameter("@WarehouseId", SqlDbType.Int));
cmd.Parameters["@WarehouseId"].Value = WarehouseId;
dt = DatabaseCls1.FillAdapter(cmd);
return(dt);
}
//ADD DATA IN DepartmentMASTER TABLE
public static int SpObjectiveEvaluationAddData(string masterid, string employeeid, string evaluationnote, string statusid, string percentage)
{
// get a configured DbCommand object
DbCommand comm = DataAccess.CreateCommand();
// set the stored procedure name
comm.CommandText = "SpObjectiveEvaluationAddData";
// create a new parameter
DbParameter param = comm.CreateParameter();
param.ParameterName = "@masterid";
param.Value = masterid;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@date";
param.Value = employeeid;
param.DbType = DbType.String;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@evaluationnote";
param.Value = evaluationnote;
param.DbType = DbType.String;
param.Size = 80000;
comm.Parameters.Add(param);
//param = comm.CreateParameter();
//param.ParameterName = "@statusid";
//param.Value = statusid;
//param.DbType = DbType.Int32;
//comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@percentage";
param.Value = percentage;
param.DbType = DbType.Decimal;
comm.Parameters.Add(param);
comm.Parameters.Add(new SqlParameter("@EvaluationId", SqlDbType.Int));
comm.Parameters["@EvaluationId"].Direction = ParameterDirection.Output;
comm.Parameters.Add(new SqlParameter("@ReturnValue", SqlDbType.Int));
comm.Parameters["@ReturnValue"].Direction = ParameterDirection.ReturnValue;
Int32 result = DatabaseCls1.ExecuteNonQueryep(comm);
//if (result > 0)
//{
result = Convert.ToInt32(comm.Parameters["@EvaluationId"].Value);
//}
return(result);
}
public static DataTable SelectDepartmentmasterMNCwithCID()
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
cmd.CommandText = "SelectDepartmentmasterMNCwithCID";
cmd.Parameters.Add(new SqlParameter("@CID", SqlDbType.NVarChar));
cmd.Parameters["@CID"].Value = HttpContext.Current.Session["Comid"].ToString();
dt = DatabaseCls1.FilleppAdapter(cmd); //.FillAdapter(cmd);
return(dt);
}
public static DataTable SelectWhidwithdeptid(String deptid)
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
cmd.CommandText = "SelectWhidwithdeptid";
cmd.Parameters.Add(new SqlParameter("@deptid", SqlDbType.NVarChar));
cmd.Parameters["@deptid"].Value = deptid;
dt = DatabaseCls1.FilleppAdapter(cmd); //.FillAdapter(cmd);
return(dt);
}
public DataTable selectCompanyMaster()
{
cmd = new SqlCommand();
DataTable dtr = new DataTable();
cmd.CommandText = "selectCompanyMaster";
cmd.Parameters.Add(new SqlParameter("@CompanyName", SqlDbType.NVarChar));
cmd.Parameters["@CompanyName"].Value = HttpContext.Current.Session["Comid"].ToString(); // CompanyLoginId;
dtr = DatabaseCls1.FilleppAdapter(cmd);
return(dtr);
}
public static DataTable SelectOfficeManagerDocumentsforWDetailID(string MgId)
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
cmd.CommandText = "SelectOfficeManagerDocumentsforWDetailID";
cmd.Parameters.Add(new SqlParameter("@MgId", SqlDbType.NVarChar));
cmd.Parameters["@MgId"].Value = MgId; // Convert.ToInt32(HttpContext.Current.Session["EmployeeId"].ToString()); // EmployeeId;
dt = DatabaseCls1.FilleppAdapter(cmd); //.FillAdapter(cmd);
return(dt);
}
public static DataTable SelctWeekonmonth(string Year)
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
cmd.CommandText = "SelctWeekonmonth";
cmd.Parameters.Add(new SqlParameter("@Year", SqlDbType.NVarChar));
cmd.Parameters["@Year"].Value = Year; // Convert.ToInt32(HttpContext.Current.Session["EmployeeId"].ToString()); // EmployeeId;
dt = DatabaseCls1.FilleppAdapter(cmd); //.FillAdapter(cmd);
return(dt);
}
public static DataTable SelectobjActualcostforMMaster(string MissionId)
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
cmd.CommandText = "SelectobjActualcostforMMaster";
cmd.Parameters.Add(new SqlParameter("@MasterId", SqlDbType.NVarChar));
cmd.Parameters["@MasterId"].Value = MissionId; // Convert.ToInt32(HttpContext.Current.Session["EmployeeId"].ToString()); // EmployeeId;
dt = DatabaseCls1.FilleppAdapter(cmd); //.FillAdapter(cmd);
return(dt);
}
