public static bool Save(User objUser, User currentUser) { int result = 0; UserCompany CurrentCompany = new UserCompany(); string strSaveQry, strEncryptPwd; if (objUser.IsNew) { strSaveQry = "Insert into UserProfile (DBID, FIRSTNAME, LOGINNAME, PASSWORD, ROLE, " + " BRANCHCODE, COMPANYCODE, ST_DATE, MODIFY_DATE, DEPT, ISACTIVE, DEPTHEAD, CRBY, MODBY, MACHINENAME) " + " VALUES ( @dbid, @FirstName, @LoginName, @Password, @Role, " + " @BranchCode, @CompanyCode, @StDate, @ModifyDate, @Dept, @IsActive, @DeptHead, " + " @CrBy, @ModBy, @MachineName)"; } else { strSaveQry = "UPDATE UserProfile " + "set FIRSTNAME = @FirstName, LOGINNAME = @LoginName, PASSWORD = @Password, " + " ROLE = @Role, BRANCHCODE = @BranchCode, COMPANYCODE = @CompanyCode, " + " MODIFY_DATE = @ModifyDate, DEPT = @Dept, ISACTIVE = @IsActive, DEPTHEAD = @DeptHead, " + " MODBY = @ModBy, MACHINENAME = @MachineName " + " WHERE DBID = @dbid "; } SqlConnection Conn = new SqlConnection(General.GetSQLConnectionString()); SqlCommand objCmd = new SqlCommand(); try { // Temporary disabled as stored procedure is not created. //strEncryptPwd = GetEncryptPwd(objUser.Password); strEncryptPwd = objUser.Password; objCmd.Connection = Conn; objCmd.CommandType = CommandType.Text; objCmd.CommandText = strSaveQry; objCmd.Parameters.AddWithValue("@dbid", objUser.DBID); objCmd.Parameters.AddWithValue("@FirstName", objUser.FirstName); objCmd.Parameters.AddWithValue("@LoginName", objUser.LoginName); objCmd.Parameters.AddWithValue("@Password", strEncryptPwd); objCmd.Parameters.AddWithValue("@Role", objUser.Role); objCmd.Parameters.AddWithValue("@BranchCode", objUser.BranchCode); objCmd.Parameters.AddWithValue("@CompanyCode", objUser.CompanyCode); if (objUser.IsNew) { objCmd.Parameters.AddWithValue("@StDate", DateTime.Now); objCmd.Parameters.AddWithValue("@CrBy", currentUser.LoginName); objUser.DBID = GenerateDBID(); } objCmd.Parameters.AddWithValue("@ModifyDate", DateTime.Now); objCmd.Parameters.AddWithValue("@ModBy", currentUser.LoginName); objCmd.Parameters.AddWithValue("@MachineName", General.GetMachineName()); objCmd.Parameters.AddWithValue("@Dept", objUser.Dept); objCmd.Parameters.AddWithValue("@IsActive", objUser.IsActive); objCmd.Parameters.AddWithValue("@DeptHead", objUser.DeptHead); if (Conn.State != ConnectionState.Open) { Conn.Open(); } result = objCmd.ExecuteNonQuery(); objCmd.Dispose(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { Conn.Close(); Conn.Dispose(); } return(result > 0); }
/// <summary> /// This method Saves Record into Database. /// </summary> /// <param name="objRetDC">Object containing Data values to be saved.</param> /// <returns>Boolean value True if Record is saved successfully /// otherwise returns False indicating Record is not saved.</returns> public static bool Save(ReturnableDC objRetDC, User currentUser) { int result = 0; UserCompany CurrentCompany = new UserCompany(); using (SqlConnection Conn = new SqlConnection(General.GetSQLConnectionString())) { string strSaveQry; if (objRetDC.IsNew) { strSaveQry = "INSERT INTO RETURNABLEDC(DBID, ENTRYNO, ENTRYDATE, ENTRYTYPE, " + " PARTYNAME, VEHICLENO, DCNO, DCDATE, PLANT, VINDATE, VINTIME, VOUTDATE, " + " VOUTTIME, ST_DATE, MODIFY_DATE, CRBY, MODBY, MACHINENAME) " + " VALUES (@dbId, @EntryNo, @EntryDate, @EntryType, @PartyName, @VehicleNo, " + " @DCNo, @DCDate, @Plant, @VinDate, @VinTime, @VOutDate, @VoutTime, " + " @STDate, @ModifyDate, @CrBy, @ModBy, @MachineName)"; } else { strSaveQry = "UPDATE RETURNABLEDC " + " SET ENTRYNO = @EntryNo, ENTRYDATE = @EntryDate, ENTRYTYPE = @EntryType, " + " PARTYNAME = @PartyName, VEHICLENO = @VehicleNo, DCNO = @DCNo, " + " DCDATE = @DCDate, PLANT = @Plant, VINDATE = @VInDate, VINTIME = @VInTime, " + " VOUTDATE = @VOutDate, VOUTTIME = @VOutTime, MODIFY_DATE = @ModifyDate, " + " MODBY = @ModBy, MACHINENAME = @MachineName " + " WHERE DBID = @dbId"; } try { SqlCommand objCmd = Conn.CreateCommand(); objCmd.CommandType = CommandType.Text; objCmd.CommandText = strSaveQry; objCmd.Parameters.AddWithValue("@EntryDate", objRetDC.EntryDate); objCmd.Parameters.AddWithValue("@EntryType", objRetDC.EntryType); objCmd.Parameters.AddWithValue("@PartyName", objRetDC.PartyName); if (objRetDC.VehicleNo == string.Empty) { objCmd.Parameters.AddWithValue("@VehicleNo", DBNull.Value); } else { objCmd.Parameters.AddWithValue("@VehicleNo", objRetDC.VehicleNo); } objCmd.Parameters.AddWithValue("@DCNo", objRetDC.DCNo); objCmd.Parameters.AddWithValue("@DCDate", objRetDC.DCDate); objCmd.Parameters.AddWithValue("@Plant", objRetDC.PlantName); if (objRetDC.VInDate == DateTime.MinValue) { objCmd.Parameters.AddWithValue("@VInDate", DBNull.Value); } else { objCmd.Parameters.AddWithValue("@VInDate", objRetDC.VInDate); } if (objRetDC.VInTime == DateTime.MinValue) { objCmd.Parameters.AddWithValue("@VInTime", DBNull.Value); } else { objCmd.Parameters.AddWithValue("@VInTime", objRetDC.VInTime); } if (objRetDC.VOutDate == DateTime.MinValue) { objCmd.Parameters.AddWithValue("@VOutDate", DBNull.Value); } else { objCmd.Parameters.AddWithValue("@VOutDate", objRetDC.VOutDate); } if (objRetDC.VOutTime == DateTime.MinValue) { objCmd.Parameters.AddWithValue("@VOutTime", DBNull.Value); } else { objCmd.Parameters.AddWithValue("@VOutTime", objRetDC.VOutTime); } if (objRetDC.IsNew) { objCmd.Parameters.AddWithValue("@StDate", DateTime.Now); objCmd.Parameters.AddWithValue("@CrBy", currentUser.LoginName); //objRetDC.DBID = General.GenerateDBID(Conn, "RETURNABLEDC"); objRetDC.DBID = General.GenerateDBID("SEQDCID", Conn); objRetDC.EntryNo = objRetDC.DBID; } objCmd.Parameters.AddWithValue("@ModifyDate", DateTime.Now); objCmd.Parameters.AddWithValue("@ModBy", currentUser.LoginName); objCmd.Parameters.AddWithValue("@MachineName", General.GetMachineName()); objCmd.Parameters.AddWithValue("@dbID", objRetDC.DBID); objCmd.Parameters.AddWithValue("@EntryNo", objRetDC.EntryNo); if (Conn.State != ConnectionState.Open) { Conn.Open(); } result = objCmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } } return(result > 0); }