public static int InsertInformation(A2ZSUPPLIERDTO dto) { SqlDateTime sqldatenull; sqldatenull = SqlDateTime.Null; SqlParameter param1 = new SqlParameter("@SuppStatDate", DBNull.Value); if (dto.NullSuppStatDate == "") { param1 = new SqlParameter("@SuppStatDate", DBNull.Value); } else { param1 = new SqlParameter("@SuppStatDate", dto.SuppStatDate); } dto.SuppName = (dto.SuppName != null) ? dto.SuppName.Trim().Replace("'", "''") : ""; int rowEffect = 0; string strQuery = @"INSERT into A2ZSUPPLIER(SuppCode,SuppName,SuppAddL1,SuppAddL2,SuppAddL3,SuppTel,SuppMobile,SuppFax,SuppEmail,SuppStatDate,SuppStatus,SuppStatDesc)values('" + dto.SuppCode + "','" + dto.SuppName + "','" + dto.SuppAddL1 + "','" + dto.SuppAddL2 + "','" + dto.SuppAddL3 + "','" + dto.SuppTel + "','" + dto.SuppMobile + "','" + dto.SuppFax + "','" + dto.SuppEmail + "','" + param1.Value + "', '1', 'Active')"; rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZSTMCUS")); if (rowEffect == 0) { return(0); } else { return(1); } }
public static int UpdateInformation(A2ZSUPPLIERDTO dto) { dto.SuppName = (dto.SuppName != null) ? dto.SuppName.Trim().Replace("'", "''") : ""; int rowEffect = 0; string strQuery = "UPDATE A2ZSUPPLIER set SuppCode='" + dto.SuppCode + "',SuppName='" + dto.SuppName + "',SuppAddL1='" + dto.SuppAddL1 + "',SuppAddL2='" + dto.SuppAddL2 + "',SuppAddL3='" + dto.SuppAddL3 + "',SuppTel='" + dto.SuppTel + "',SuppMobile='" + dto.SuppMobile + "',SuppFax='" + dto.SuppFax + "',SuppEmail='" + dto.SuppEmail + "' where SuppCode ='" + dto.SuppCode + "'"; rowEffect = Converter.GetInteger(BLL.CommonManager.Instance.ExecuteNonQuery(strQuery, "A2ZSTMCUS")); if (rowEffect == 0) { return(0); } else { return(1); } }
public static A2ZSUPPLIERDTO GetInformation(int SuppCode) { A2ZCSPARAMETERDTO dto2 = A2ZCSPARAMETERDTO.GetParameterValue(); DateTime dt2 = Converter.GetDateTime(dto2.ProcessDate); string date1 = dt2.ToString("dd/MM/yyyy"); var prm1 = new object[3]; prm1[0] = SuppCode; prm1[1] = Converter.GetDateToYYYYMMDD(date1); prm1[2] = 0; DataTable dt3 = BLL.CommonManager.Instance.GetDataTableBySpWithParams("SpM_STGenerateSingleLedgerBalance", prm1, "A2ZSTMCUS"); DataTable dt = BLL.CommonManager.Instance.GetDataTableByQuery("SELECT * FROM A2ZSUPPLIER WHERE SuppCode = " + SuppCode, "A2ZSTMCUS"); var p = new A2ZSUPPLIERDTO(); if (dt.Rows.Count > 0) { p.SuppCode = Converter.GetInteger(dt.Rows[0]["SuppCode"]); p.SuppName = Converter.GetString(dt.Rows[0]["SuppName"]); p.SuppAddL1 = Converter.GetString(dt.Rows[0]["SuppAddL1"]); p.SuppAddL2 = Converter.GetString(dt.Rows[0]["SuppAddL2"]); p.SuppAddL3 = Converter.GetString(dt.Rows[0]["SuppAddL3"]); p.SuppTel = Converter.GetString(dt.Rows[0]["SuppTel"]); p.SuppMobile = Converter.GetString(dt.Rows[0]["SuppMobile"]); p.SuppFax = Converter.GetString(dt.Rows[0]["SuppFax"]); p.SuppEmail = Converter.GetString(dt.Rows[0]["SuppEmail"]); p.SuppBalance = Converter.GetDecimal(dt.Rows[0]["SuppBalance"]); p.SuppVATAmt = Converter.GetDecimal(dt.Rows[0]["SuppVATAmt"]); p.SuppTAXAmt = Converter.GetDecimal(dt.Rows[0]["SuppTAXAmt"]); return(p); } p.SuppCode = 0; return(p); }