//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); }