public static void UpdateParty(string code, string desc, string accode, string add1, string add2, string ph, string fax, string city, string det)
{
SQLAccess sq = new SQLAccess(DbConfig.GetConStr("MAINDB"));
string qry = "update party set pname = '" + desc + "',p_acccode= '" + accode + "',address1 = '" + add1 + "',address2 = '" + add2 + "',phone = '" + ph + "', fax = '" + fax + "',city = '" + city + "',otherdetail = '" + det + "' where pcode = '" + code + "'";
sq.ExecuteNonQuery(qry);
}
public static void UpdateGroup(string code, string desc)
{
SQLAccess sq = new SQLAccess(DbConfig.GetConStr("MAINDB"));
string qry = "update IGroup set gname = '" + desc + "' where gcode = '" + code + "'";
sq.ExecuteNonQuery(qry);
}
public static void DeleteItem(string code)
{
SQLAccess sq = new SQLAccess(DbConfig.GetConStr("MAINDB"));
string qry = "delete from ItemMaster where itemcode = '" + code + "'";
sq.ExecuteNonQuery(qry);
}
public static void UpdateItem(string code, string desc, string grp, string unit, decimal rate, decimal qty, decimal val, string vendor)
{
SQLAccess sq = new SQLAccess(DbConfig.GetConStr("MAINDB"));
string qry = "update ItemMaster set itemdesc = '" + desc + "',itemgp= '" + grp + "',unit = '" + unit + "',rate = " + rate + ",qty = " + qty + ", stockvalue =" + val + ",vendor = '" + vendor + "' where itemcode = '" + code + "'";
sq.ExecuteNonQuery(qry);
}
public static void UpdateGroup(string acode, string adesc, string type, decimal curbal)
{
SQLAccess sq = new SQLAccess(DbConfig.GetConStr("MAINDB"));
sq.ExecuteNonQuery("Update FAGroup set A_DESC='" + acode + "'," + "A_TYPE ='" + type + "',A_CURRB ='" +
curbal.ToString() + "' where A_CODE = '" + acode + "'");
}
public static void DeleteGroup(string code)
{
SQLAccess sq = new SQLAccess(DbConfig.GetConStr("MAINDB"));
string qry = "delete from IGroup where gcode = '" + code + "'";
sq.ExecuteNonQuery(qry);
}
public object Delete(string connectionstr, int UserId)
{
sqlacc = new SQLAccess();
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_tb_User";//Name of Stored Procedure
cmd.Parameters.AddWithValue("@UserId", UserId);
cmd.Parameters.AddWithValue("@Mode", 5);
return(sqlacc.ExecuteNonQuery(connectionstr, cmd));
}
public static void AddGroup(string code, string desc)
{
SQLAccess sqlacess = new SQLAccess(DbConfig.GetConStr("MAINDB"));
string qry = "insert into IGroup values('" + code + "','" + desc + "')";
if (!sqlacess.ExecuteNonQuery(qry))
{
return;
}
}
public static void AddParty(string code, string desc, string accode, string add1, string add2, string ph, string fax, string city, string det)
{
SQLAccess sqlacess = new SQLAccess(DbConfig.GetConStr("MAINDB"));
string qry = "insert into party values('" + code + "','" + desc + "','" + accode + "','" + add1 + "','" + add2 + "','" + ph + "','" + fax + "','" + city + "','" + det + "')";
if (!sqlacess.ExecuteNonQuery(qry))
{
return;
}
}
public static void AddItem(string code, string desc, string grp, string unit, decimal rate, decimal qty, decimal val, string vendor)
{
SQLAccess sqlacess = new SQLAccess(DbConfig.GetConStr("MAINDB"));
string qry = "insert into ItemMaster values('" + code + "','" + desc + "','" + grp + "','" + unit + "'," + rate + "," + qty + "," + val + ",'" + vendor + "')";
if (!sqlacess.ExecuteNonQuery(qry))
{
return;
}
}
public static void DeleteSubGroup(string scode)
{
// SPAccess sp = new SPAccess(DbConfig.GetConStr("MAINDB"));
// sp.Add("@S_CODE", typeof(System.String), scode);
// sp.ExecuteNonQuery("spDeleteFASubGroup");
SQLAccess sq = new SQLAccess(DbConfig.GetConStr("MAINDB"));
sq.ExecuteNonQuery("Delete from FASubGroup where S_CODE = '" + scode + "'");
}
public object CheckUser(string connectionstr, string EmailId, string Password)
{
sqlacc = new SQLAccess();
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_tb_User";//Name of Stored Procedure
cmd.Parameters.AddWithValue("@EmailId", EmailId);
cmd.Parameters.AddWithValue("@Password", Password);
cmd.Parameters.AddWithValue("@Mode", 6);
return(sqlacc.ExecuteNonQuery(connectionstr, cmd));
}
public static bool DoPost(Transaction t)
{
SQLAccess sq = new SQLAccess(DbConfig.GetConStr("MAINDB"));
try
{
string qry = "insert into TransactionMaster values('" + t.invo + "','" + t.cr + "','" + t.refno + "','" + DateTime.Now + "'," +
"'" + t.add + "','" + t.type + "'," + t.total + "," + t.gtotal + "," + t.discount + "," + t.freight + ",'" + t.cterms + "')";
sq.ExecuteNonQuery(qry);
List <TransactionEntry> te = t.rs;
foreach (TransactionEntry ts in te)
{
qry = "insert into transactionDetail values('" + t.invo + "','" + ts.iname + "'," + ts.qty + ",'" + ts.unit + "'," + ts.rate + "," + ts.val + ")";
sq.ExecuteNonQuery(qry);
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public static void AddGroup(string acode, string adesc, string type, decimal curbal)
{
//SPAccess sp = new SPAccess(DbConfig.GetConStr("MAINDB"));
//sp.Add("@A_CODE", typeof(System.String), acode);
//sp.Add("@A_DESC", typeof(System.String), adesc);
//sp.Add("@A_TYPE", typeof(System.String), type);
//sp.Add("@A_CURRB", typeof(System.Decimal), curbal);
// sp.ExecuteNonQuery("spCreateFAGroup");
SQLAccess sq = new SQLAccess(DbConfig.GetConStr("MAINDB"));
sq.ExecuteNonQuery("INSERT into FAGroup values ('" + acode + "'," +
"'" + adesc + "'," + "'" + type + "'," + curbal.ToString() + ")");
}
public static void AddSubGroup(string scode, string sdesc, string stype, decimal opbal, string drcr, string flag)
{
//SPAccess sp = new SPAccess(DbConfig.GetConStr("MAINDB"));
//sp.Add("@S_CODE", typeof(System.String), scode);
//sp.Add("@S_DESC", typeof(System.String), sdesc);
//sp.Add("@S_TYPE", typeof(System.String), stype);
//sp.Add("@S_OPBAL", typeof(System.String), opbal);
//sp.Add("@S_DRCR", typeof(System.String), drcr);
//sp.Add("@S_FLAG", typeof(System.String), flag);
//sp.ExecuteNonQuery("spCreateFASubGroup");
SQLAccess sq = new SQLAccess(DbConfig.GetConStr("MAINDB"));
sq.ExecuteNonQuery("INSERT into FASubGroup values ('" + scode + "'," +
"'" + sdesc + "'," + "'" + stype + "'," + opbal.ToString() + ",'" + drcr + "','" + flag + "')");
}
public static void UpdateSubGroup(string scode, string sdesc, string stype, decimal opbal, string drcr, string flag)
{
//SPAccess sp = new SPAccess(DbConfig.GetConStr("MAINDB"));
//sp.Add("@S_CODE", typeof(System.String), scode);
//sp.Add("@S_DESC", typeof(System.String), sdesc);
//sp.Add("@S_TYPE", typeof(System.String), stype);
//sp.Add("@S_OPBAL", typeof(System.String), opbal);
//sp.Add("@S_DRCR", typeof(System.String), drcr);
//sp.Add("@S_FLAG", typeof(System.String), flag);
//sp.ExecuteNonQuery("spUpdateFASubGroup");
SQLAccess sq = new SQLAccess(DbConfig.GetConStr("MAINDB"));
sq.ExecuteNonQuery("Update FASubGroup set S_DESC='" + sdesc + "'," + "S_TYPE ='" + stype + "',S_OPBAL ='" +
opbal.ToString() + "',S_DRCR='" + drcr + "',S_FLAG='" + flag + "'" + " where S_CODE = '" + scode + "'");
}
public object AddEdit(string connectionstr, UserModel usermodel, bool Insert)
{
sqlacc = new SQLAccess();
cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_tb_User";//Name of Stored Procedure
cmd.Parameters.AddWithValue("@UserId", usermodel.Id);
cmd.Parameters.AddWithValue("@UserName", usermodel.UserName);
cmd.Parameters.AddWithValue("@EmailId", usermodel.EmailId);
cmd.Parameters.AddWithValue("@Mobile", usermodel.Mobile);
cmd.Parameters.AddWithValue("@Address", usermodel.Address);
cmd.Parameters.AddWithValue("@IsActive", usermodel.IsActive);
if (Insert)
{
cmd.Parameters.AddWithValue("@Mode", 3);
}
else
{
cmd.Parameters.AddWithValue("@Mode", 4);
}
return(sqlacc.ExecuteNonQuery(connectionstr, cmd));
}
public static void DeleteGroup(string acode)
{
SQLAccess sq = new SQLAccess(DbConfig.GetConStr("MAINDB"));
sq.ExecuteNonQuery("Delete from FAGroup where A_CODE = '" + acode + "'");
}