public bool DeleteTEWayDetails(TEWayDetails tewaydetails) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "DeleteTEWayDetails"; cmd.Parameters.AddWithValue("@PKEWayNo", tewaydetails.PKEWayNo); if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true) { return(true); } else { tewaydetails.msg = ObjTrans.ErrorMessage; return(false); } }
public bool AddTEWayDetails(TEWayDetails tewaydetails) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddTEWayDetails"; cmd.Parameters.AddWithValue("@PKEWayNo", tewaydetails.PKEWayNo); cmd.Parameters.AddWithValue("@FkVoucherNo", tewaydetails.FkVoucherNo); cmd.Parameters.AddWithValue("@EWayNo", tewaydetails.EWayNo); cmd.Parameters.AddWithValue("@VoucherUserNo", tewaydetails.VoucherUserNo); cmd.Parameters.AddWithValue("@EWayDate", tewaydetails.EWayDate); cmd.Parameters.AddWithValue("@ModeNo", tewaydetails.ModeNo); cmd.Parameters.AddWithValue("@Distance", tewaydetails.Distance); cmd.Parameters.AddWithValue("@TransportNo", tewaydetails.TransportNo); cmd.Parameters.AddWithValue("@VehicleNo", tewaydetails.VehicleNo); cmd.Parameters.AddWithValue("@LRNo", tewaydetails.LRNo); cmd.Parameters.AddWithValue("@LRDate", tewaydetails.LRDate); cmd.Parameters.AddWithValue("@LedgerNo", tewaydetails.LedgerNo); cmd.Parameters.AddWithValue("@LedgerName", tewaydetails.LedgerName); cmd.Parameters.AddWithValue("@Address", tewaydetails.Address); cmd.Parameters.AddWithValue("@CityNo", tewaydetails.CityNo); cmd.Parameters.AddWithValue("@CityName", tewaydetails.CityName); cmd.Parameters.AddWithValue("@PinCode", tewaydetails.PinCode); cmd.Parameters.AddWithValue("@StateCode", tewaydetails.StateCode); cmd.Parameters.AddWithValue("@StateName", tewaydetails.StateName); cmd.Parameters.AddWithValue("@UserID", tewaydetails.UserID); cmd.Parameters.AddWithValue("@UserDate", tewaydetails.UserDate); //cmd.Parameters.AddWithValue("@ModifiedBy", tewaydetails.ModifiedBy); cmd.Parameters.AddWithValue("@StatusNo", tewaydetails.StatusNo); cmd.Parameters.AddWithValue("@IsActive", tewaydetails.IsActive); cmd.Parameters.AddWithValue("@TranspotorNm", tewaydetails.TranspotorNm); if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true) { return(true); } else { tewaydetails.msg = ObjTrans.ErrorMessage; return(false); } }
//public DataView GetAllMArea() //{ // SqlConnection Con = new SqlConnection(CommonFunctions.ConStr); // string sql = "Select * from MArea order by AreaNo"; // SqlDataAdapter da = new SqlDataAdapter(sql, Con); // DataSet ds = new DataSet(); // try // { // da.Fill(ds); // } // catch { throw; } // finally // { // Con.Close(); // } // return ds.Tables[(0)].DefaultView; //} public TEWayDetails ModifyTEWayDetailsByID(long ID) { SqlConnection Con = new SqlConnection(CommonFunctions.ConStr); string sql; SqlCommand cmd; sql = "Select * from TEWayDetails where FkVoucherNo = " + ID; cmd = new SqlCommand(sql, Con); cmd.Connection = Con; Con.Open(); cmd.CommandType = CommandType.Text; SqlDataReader dr; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (dr.HasRows) { TEWayDetails MM = new TEWayDetails(); while (dr.Read()) { MM.PKEWayNo = Convert.ToInt64(dr["PKEWayNo"]); if (!Convert.IsDBNull(dr["FkVoucherNo"])) { MM.FkVoucherNo = Convert.ToInt32(dr["FkVoucherNo"]); } if (!Convert.IsDBNull(dr["EWayNo"])) { MM.EWayNo = Convert.ToString(dr["EWayNo"]); } if (!Convert.IsDBNull(dr["VoucherUserNo"])) { MM.VoucherUserNo = Convert.ToInt64(dr["VoucherUserNo"]); } if (!Convert.IsDBNull(dr["EWayDate"])) { MM.EWayDate = Convert.ToDateTime(dr["EWayDate"]); } if (!Convert.IsDBNull(dr["ModeNo"])) { MM.ModeNo = Convert.ToInt64(dr["ModeNo"]); } if (!Convert.IsDBNull(dr["Distance"])) { MM.Distance = Convert.ToDouble(dr["Distance"]); } if (!Convert.IsDBNull(dr["TransportNo"])) { MM.TransportNo = Convert.ToInt64(dr["TransportNo"]); } if (!Convert.IsDBNull(dr["VehicleNo"])) { MM.VehicleNo = Convert.ToString(dr["VehicleNo"]); } if (!Convert.IsDBNull(dr["LRNo"])) { MM.LRNo = Convert.ToString(dr["LRNo"]); } if (!Convert.IsDBNull(dr["LRDate"])) { MM.LRDate = Convert.ToDateTime(dr["LRDate"]); } if (!Convert.IsDBNull(dr["LedgerNo"])) { MM.LedgerNo = Convert.ToInt32(dr["LedgerNo"]); } if (!Convert.IsDBNull(dr["LedgerName"])) { MM.LedgerName = Convert.ToString(dr["LedgerName"]); } if (!Convert.IsDBNull(dr["Address"])) { MM.Address = Convert.ToString(dr["Address"]); } if (!Convert.IsDBNull(dr["CityNo"])) { MM.CityNo = Convert.ToInt64(dr["CityNo"]); } if (!Convert.IsDBNull(dr["CityName"])) { MM.CityName = Convert.ToString(dr["CityName"]); } if (!Convert.IsDBNull(dr["PinCode"])) { MM.PinCode = Convert.ToInt64(dr["PinCode"]); } if (!Convert.IsDBNull(dr["StateCode"])) { MM.StateCode = Convert.ToInt64(dr["StateCode"]); } if (!Convert.IsDBNull(dr["StateName"])) { MM.StateName = Convert.ToString(dr["StateName"]); } if (!Convert.IsDBNull(dr["UserID"])) { MM.UserID = Convert.ToInt64(dr["UserID"]); } if (!Convert.IsDBNull(dr["UserDate"])) { MM.UserDate = Convert.ToDateTime(dr["UserDate"]); } if (!Convert.IsDBNull(dr["ModifiedBy"])) { MM.ModifiedBy = Convert.ToString(dr["ModifiedBy"]); } if (!Convert.IsDBNull(dr["StatusNo"])) { MM.StatusNo = Convert.ToInt32(dr["StatusNo"]); } if (!Convert.IsDBNull(dr["IsActive"])) { MM.Address = Convert.ToString(dr["IsActive"]); } if (!Convert.IsDBNull(dr["TranspotorNm"])) { MM.TranspotorNm = Convert.ToString(dr["TranspotorNm"]); } } dr.Close(); return(MM); } else { dr.Close(); } return(new TEWayDetails()); }