public Boolean saveCustomerData(String CUST_FNAME, String CUST_LNAME, String CUST_MOB, String CUST_EMAIL, String CUST_STATE, String CUST_DISTRICT, String CUST_AREA, String CUST_IMG_LOC) { this.CUST_FNAME = CUST_FNAME.Trim(); this.CUST_LNAME = CUST_LNAME.Trim(); this.CUST_MOB = CUST_MOB.Trim(); this.CUST_EMAIL = CUST_EMAIL.Trim(); this.CUST_STATE = CUST_STATE; this.CUST_DISTRICT = CUST_DISTRICT; this.CUST_AREA = CUST_AREA; this.CUST_IMG_LOC = CUST_IMG_LOC; String CUST_ID = GenerateUniqueID.RandomString(8); if (!(String.IsNullOrEmpty(CUST_IMG_LOC))) { String fileExtension = Path.GetExtension(CUST_IMG_LOC); this.CUST_IMG_FILENAME = CUST_ID + fileExtension; if (!(copyUtils.copyImag(CUST_IMG_LOC, CUST_IMG_FILENAME))) { return(false); } } else { this.CUST_IMG_FILENAME = ""; } //String CUST_ID = "5L9OSNKD"; insertQuery = "insert into " + tableName + " values('" + CUST_FNAME + "','" + CUST_LNAME + "','" + CUST_MOB + "','" + CUST_EMAIL + "','" + CUST_STATE + "','" + CUST_DISTRICT + "','" + CUST_AREA + "','" + AppConstant.IMG_TRAGET_PATH + "','" + CUST_IMG_FILENAME + "', " + " '" + CUST_ID + "');"; if (!(dataAccessUtility.iscolumnAlreadyPresent(tableName, "CUST_ID", CUST_ID))) { result = insertData(insertQuery); } else { MessageBox.Show("SomeThing Went Wrong!! Please try Again"); } if (!(dataAccessUtility.iscolumnAlreadyPresent(tableName, "CUST_FNAME", CUST_FNAME, "CUST_LNAME", CUST_LNAME, "CUST_AREA", CUST_AREA))) { result = insertData(insertQuery); } else { MessageBox.Show(CUST_FNAME + " " + CUST_LNAME + " " + CUST_AREA + " Is Already Present"); } return(result); }